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