Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to create a date because i only have the YEAR on my field and i would set the date 01/01/YEAR for example, and convert to integer this date into my field AsOf.
The Script:
The AsOf field:
How can i do that please ?
Thanks you in advance for your help.
Sébastien.
MakeDate(YEAR,1,1) AS AsOf_Date
To make it a number:
Num(MakeDate(YEAR,1,1)) AS AsOf_Date
MakeDate(YEAR,1,1) AS AsOf_Date
To make it a number:
Num(MakeDate(YEAR,1,1)) AS AsOf_Date
try like this
date(YEAR) as AsOf
you will get date field
then you can derive year from that
year(AsOf) as year
Thanks a lot it works perfectly !