How to create as load script for DATE from combine of day month year field ?

[paulyeo11]

Hi All

I have 3 field month and year when load script :-

1 as day,

@50:52T  as month,

@53:57T  as year,

I want to add one more script , so that i will get DATE field .

So that it will become dd/mm/yyyy

Some thing like below :-

1 + @50:52T +  @53:57T as DATE,

But above does not return the correct date, May i know how to do ?

Paul

[paulyeo11]

Enclosed my QV doc

[martinpohl]

What values are in the fields 50-57?

Look at "makedate"-syntax

Regards

[martinpohl · Accepted solution]

failed to open document

[perumal_41]

Hi

use makedate function. ie date(makedate(year,month,day))

[ashfaq_haseeb]

Hi,

Look at makedate() function.

Regards

ASHFAQ

[PrashantSangle]

Hi,

try like this

makedate(@53:57T,@50:52T,1) as newDate

Regards

[giakoum]

Martin already suggested the makedate function.

I don't see why you guys keep suggesting the same thing again and again...

[paulyeo11]

Hi All

Thank you every one for your contribution. Personally i like the below suggestion :-

makedate(@53:57T,@50:52T,1) as newDate

So all are right , but many choice make life simple.

Paul