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: 
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.