num DATE

[upaliwije]

Hi friends

In QV data load syntax I have following line

Num(YEAR(T_DATE))& num(MONTH(T_DATE))AS TD_YM, and the result is shown below

T_DATE      TD_YM       expeceted TD_YM
31/07/18     20187            201807
01/10/18     201810         201810

In the actual output   T_date 31/07/18 is shown with 5 dights (20187) whereas I want it to be in 6 digits (201807 ). Kindly help me to modify my script to get expected output.

[Brett_Bleess]

My bad here, when I moved the post, I did not get everything, here is the link to the replies on this one:

https://community.qlik.com/t5/QlikView-App-Development/Re-num-DATE/m-p/1554616#M440616

Apologies,
Brett