Survey123 pulldata from csv does not work for Australian Date format

JohnBickmore — Wed, 20 Mar 2024 00:11:19 GMT

I have been extremely frustrated trying to use pulldata from csv into a date field

When I pull the date as text (type) - it show exactly as it is in the csv table eg 25/1/2023 however it defaults to 1 jan 1900 if i try to populate into a date (type).

I tried changing the date to a number in the csv and also changing to long format but nothing would work

I also was unable to convert the text version of the date into a date field.

The only solution I found that worked was formatting the date in the US format 😒 in the csv table.

=CONCAT(MONTH(E2),"/",DAY(E2),"/",YEAR(E2))

Is this a known issue? Is this something that can be improved??

I am using connect version 3.19.104

topic Survey123 pulldata from csv does not work for Australian Date format in ArcGIS Survey123 Questions

Survey123 pulldata from csv does not work for Australian Date format