Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I use the following script for loading
, Date#([Date Time],'YYYY-MM-DD') as [Date Time1]
how to change date format for Date Time1] to YYYY-MM-DD?
use Format (what is the origin Format of Date Time?)
Date([Date Time],'YYYY-MM-DD') as [Date Time1]
Seems like the numbers were interpreted as text. Have you used a CROSSTABLE LOAD before this LOAD in question?
Try
Date(num#([Date Time]),'YYYY-MM-DD') as [Date Time1]
Usefull reading: Why don’t my dates work?