
Announcements
I have a dataflow, that is attempting to import a large csv file. This csv file has a couple existing date fields: Entered & Updated.
It bombs every time on the date fields. This is how the field looks in the csv : ,"11/24/2013", The standard mm/dd/yyyy.
I've converted these fields (in Power Query) with many different types: date, date-time, text and attempted "Locale" settings. I've removed all empties
But known work.
Can anyone explain importing date fields from a dataflow?
Does anyone know an acceptable format for transformation?
Thanks,
Doug
For all: I solved this by changing the input format for the date fields, in the csv file, to YYYY-MM-DD, from MM-DD-YYYY as type TEXT. This imported fine and in Power Query, you change it to Date type.
Doug