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: 
upaliwije
Creator II
Creator II

num DATE

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.

 

1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.