Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mikaelsc
Specialist
Specialist

Re: num DATE

text(num(mont(T_Date),'00'))... but not entirely sure you really want that... 

how about :

date(monthstart(T_Date),'YYYYMM')    as TD_YM

 

like that your date field remains a date (and numerical)

1 Reply
Brett_Bleess
Former Employee
Former Employee

Here is Help link to Data and time interpretation which may help a little:
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/da...

Here is a Help link to all of the Date and time functions:
https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

This way you may see something that you can play with, many times you have to use more than one function as you were trying to do to get what you really want, but I think the poster above is on a good track here.

Regards,
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.