Create a Date into the script

[Anonymous]

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.

[ciaran_mcgowan · Accepted solution]

MakeDate(YEAR,1,1) AS AsOf_Date

To make it a number:

Num(MakeDate(YEAR,1,1)) AS AsOf_Date

[arulsettu]

try like this

date(YEAR) as AsOf

you will get date field

then you can derive year from that

year(AsOf) as year

[Anonymous]

Thanks a lot it works perfectly !