Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to create a date from month and year ?

Hi All

Now i am using below script for date field :-

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

Which is wrong , so i change the above field name to date_ ( insted of date )

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

Now i need change to using below 2 field to form the above date field :-

@50:52T  as month_,

@53:57T  as year_,

Now my question is , what is the expression should be , so that above 2 field will be able to create field name same sa date field above ?

For the day i can fill with 1.

Paul

10 Replies
paulyeo11
Master
Master
Author

Hi Sir

Thank you very much.

Sent from my android device.