Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
date(Columnname, 'MM/DD/YYYY') as Date
date(Columnname, 'MM/DD/YYYY') as Date
thanks