Convert number to date

[#1]

Hi All,

When I load my data, one of my date columns comes up with numbers instead of actual date eg '41149'. How do I convert this to a date in the load script because when I try to apply the Month(Date) function it brings back null values.

Thanks

H

[#2 · Accepted solution]

date(Columnname, 'MM/DD/YYYY') as Date

[#3]

thanks