The concatenate date (Friday, 3 Apr 2020) change to number after syncing.
Before syncing
After syncing
Formula:
Concatenate(Switch(Weekday([REPORT ID]),1,โSundayโ,2,โMondayโ,3,โTuesdayโ,4,โWednesdayโ,5,โThursdayโ,6,โFridayโ,โSaturdayโ),โ, โ ,Day([REPORT ID]),โ โ ,Switch(MONTH([REPORT ID]), 1, โJanโ, 2, โFebโ, 3, โMarโ, 4, โAprโ, 5, โMayโ, 6, โJunโ, 7, โJulโ, 8, โAugโ, 9, โSepโ, 10, โOctโ, 11, โNovโ, โDecโ),โ โ,year([REPORT ID]))
In edit mode, the date is ok.
Is this a bug in Appsheet?
Your column type is probably set as โAutomaticโ or โNumberโ. Please change itโs type to โDateโ from the spreadsheet.
Hi @justin
Does this help
Sorry guys, unfortunately, both methods donโt work for me. I tried but it still changed to number. spreadsheet is showing correctly.
Can you please try
TEXT([REPORT ID], " DDDD, DD MMM YYYY") as expression for the Day column?
Edit: However this works only for the virtual column. Real columns seem to convert it to number as you have mentioned.
Edit 2: In case of real column,please change the back end column type for [Day] to โPlain Textโ, if you are using Google sheet or suitably to similar column type โtextโ with other spreadsheet or database. With this setting of even the real column will show the date in the format you desire.
So even without trying anything else, as I suggested in my post earlier, you may first try simply changing the back end column type to "plain text"
Yeah!, works for me. Thanks!
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |