MAKE date from 2 separate columns .

[ParthKoul1]

Hi, I need to  create a date column and I have 2 different columns MMDD AND YY.

How can I create this into date in QLIK?

Thanks,

[Saravanan_Desingh]

Something like this?

tab1:
LOAD *, Date(Date#(mmdd&yy,'mmddyy')) As Date;
LOAD * INLINE [
    mmdd, yy
    1121, 20
    0106, 21
    0819, 19
];

[Saravanan_Desingh]

Output:

[QFabian]

hi @ParthKoul1 , another option is :

makedate(2000 + YY, left(MMDD, 2), right(MMDD, 2)  as Date