Create date From Three Numbers

[rebelfox]

I loading three numbers from numeric fields which represent YYYY, MM and DD.

What is a simple way of setting these three fields as a single date value in the Load statement?

[sasiparupudi1]

makedate(YYYY,MM,DD)

[Kushal_Chawda]

Try

=date(date#(YYYY&MM&DD,'YYYYMMDD'),'DD-MM-YYYY')

[#4]

Hi Roy,

Below can help to you

Temp:

LOAD * INLINE [

    YYYY, MM, DD

    2010, 09, 08

    2011, 03, 07

];

Final:

LOAD MakeDate(YYYY,MM,DD) as Date Resident Temp;

Regards,

Mahesh

[rebelfox]

Thanks, that's very easy.

[sasiparupudi1]

Hi Roy,

Great!

Please close this thread if you got your answer so that it will be helpful for others

Thanks

Sasi