CSV Date Column Downloaded empty

[Jerry_Lan]

Dear all,

Users of my deployed app commented on many missing dates in the downloaded CSV (via action). I downloaded the CSV and went to google sheet to export the same file manually into excel. Each record has a date in the excel file but not all records in the CSV. (Some records in the CSV have dates and some not. What could be the reason? About 1/3 of the 300+ records did not have any date in the csv) . Any pointers will be much appreciated guys!

With thanks,
-j- erry

[Koichi_Tsuji]

When it comes to export/import from csv and date type fields for Appsheet, the “format of date” is critically important, as apparently mm/dd/yyyy formatted date value is only appreciated.

I would suggest that you check your date type format is fine, this is only what it came up with me.

[Jerry_Lan]

Thanks @tsuji_koichi,

I think its a bug. I just tried , without much anticipation it will work,to move that date column/field up higher in the filter and now all the dates are downloaded!