Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
makedate(YYYY,MM,DD)
Try
=date(date#(YYYY&MM&DD,'YYYYMMDD'),'DD-MM-YYYY')
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
Thanks, that's very easy.
Hi Roy,
Great!
Please close this thread if you got your answer so that it will be helpful for others
Thanks
Sasi