Date format

[Anonymous]

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?

[Anonymous]

use Format (what is the origin Format of Date Time?)

Date([Date Time],'YYYY-MM-DD') as [Date Time1]

[swuehl]

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]

[Clever_Anjos]

Usefull reading: Why don’t my dates work?