Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
you need num# here
num#(Date) as Date
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;
Great stuff, thanks very much :