Hi, I have read the documentation regarding Appsheet locale, and mine is set up correctly, however the date in a virtual column expression is displayed in MMDDYYYY, not DDMMYYY like the Google sheet or the locale, the formula is:
TODAY() - WEEKDAY(TODAY()) + 2 & " to Today"
Any ideas?
Solved! Go to Solution.
Date Time display values are dependent on many settings - spreadsheet locale, AppSheet locale, device locale and browser locale.
In your case since you anyway seem to be wanting to display a text message, you could try using text functions as below to show the date in dd/mm/yyyy format
TEXT((TODAY() - WEEKDAY(TODAY()) + 2), "DD/MM/YYYY") & " to Today"
Date Time display values are dependent on many settings - spreadsheet locale, AppSheet locale, device locale and browser locale.
In your case since you anyway seem to be wanting to display a text message, you could try using text functions as below to show the date in dd/mm/yyyy format
TEXT((TODAY() - WEEKDAY(TODAY()) + 2), "DD/MM/YYYY") & " to Today"
Thankyou!!
For the date to reflect the Locale correctly, the column has to be of type Date or DateTime, not Text. If you want to use Text type then you have to manually format the text.
You can use this expression:
TEXT(TODAY() - WEEKDAY(TODAY()) + 2, "dd/mm/yyyy") & " to Today"
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |