formula to have current month in a field in yyyymm format

[P_qlik]

Hi,

I have a numeric field like this for a date: 202101 , 202102, 202103, 202104, which formula can I use to reveal the current month?

Thank you

[duchezbr · Accepted solution]

Try: 

Date(Date#([Date Field], 'YYYYMM'), 'MMM')

Using 'MMM' in the Date function will return Jan, Feb, Mar, Apr for the dates listed in your example. To return just the number (e.g., 01, 02, etc.) change 'MMM' to 'MM'

To define the current month just wrap the above expression in Max()

Max(Date(Date#([Date Field], 'YYYYMM'), 'MMM'))