Solved: Find the Current month of the Given month field - Qlik Community

Ramu_i · ‎2021-09-29

Hi All,

I have Year, Month Fields are there, In Month fields are having 01-Jan,02-Feb ....12-Dec are Names, Now I want to find the current month of the given field, Like this month is sept , so display the 09-Sep, Next Month is Oct it will display the 10-Oct.

Thanks Advance.

Regards,

Ram

micheledenardi · ‎2021-09-30

There are several solution to achieve your result, on of these is this:

=date(today(1),'MM-MMM')

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

micheledenardi · ‎2021-09-30

There are several solution to achieve your result, on of these is this:

=date(today(1),'MM-MMM')

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

Ramu_i · ‎2021-09-30

Hi Micheledenardi,

Thank you.

I got Solution.

Regards,

Ram