Convert field to date

[CNH_1978]

Hi,

I am trying to convert a field to a date but i'm really struggling. Can anyone help with the attached please?

Its a number field but i just can't seem to get it displayed as a date in the format DD/MM/YYYY

[Kushal_Chawda]

you need num# here

num#(Date) as Date

[eliran · Accepted solution]

Hi,

The part missing is below.

It doesnt recognize date as a date, since it got spaces after it, trimming did the trick.

NoConcatenate
Data_TMP1:
Load
Name,
trim(Date) as Date,
Data
Resident Data_1;
drop table Data_1;

[CNH_1978]

Great stuff, thanks very much :