num DATE

[mikaelsc]

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)

[Brett_Bleess]

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