https://community.qlik.com/t5/QlikView/Re-num-DATE/m-p/1554616#M440616 <P>text(num(mont(T_Date),'00'))... but not entirely sure you really want that...&nbsp;</P><P>how about :</P><P>date(monthstart(T_Date),'YYYYMM')&nbsp; &nbsp; as TD_YM</P><P>&nbsp;</P><P>like that your date field remains a date (and numerical)</P> Sun, 10 Mar 2019 19:01:17 GMT mikaelsc 2019-03-10T19:01:17Z https://community.qlik.com/t5/QlikView/Re-num-DATE/m-p/1554616#M440616 <P>text(num(mont(T_Date),'00'))... but not entirely sure you really want that...&nbsp;</P><P>how about :</P><P>date(monthstart(T_Date),'YYYYMM')&nbsp; &nbsp; as TD_YM</P><P>&nbsp;</P><P>like that your date field remains a date (and numerical)</P> Sun, 10 Mar 2019 19:01:17 GMT https://community.qlik.com/t5/QlikView/Re-num-DATE/m-p/1554616#M440616 mikaelsc 2019-03-10T19:01:17Z https://community.qlik.com/t5/QlikView/Re-num-DATE/m-p/1555057#M440617 <P>Here is Help link to Data and time interpretation which may help a little:<BR /><A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/date-time-interpretation.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/date-time-interpretation.htm</A></P> <P>Here is a Help link to all of the Date and time functions:<BR /><A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm" target="_blank">https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/DateAndTimeFunctions/date-time-functions.htm</A></P> <P>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.</P> <P>Regards,<BR />Brett</P> Mon, 11 Mar 2019 20:46:18 GMT https://community.qlik.com/t5/QlikView/Re-num-DATE/m-p/1555057#M440617 Brett_Bleess 2019-03-11T20:46:18Z