Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Prabhu1204
Creator
Creator

Min and max with the Format Jan-2021

Hello All,

Could you please help with the below scenario

I have a month filed with the values Jan-2021,Feb-2021,..... Jan 2022

I am facing challenges  in formatting in taking minimum and maximum month  year.

Could anyone suggest a right way ?

 

-Prabhu
1 Solution

Accepted Solutions
anat
Master
Master

convert to date then take max(field1)

date(Date#(field,'MMM-YY'),'MMM-YY') as field1

View solution in original post

2 Replies
anat
Master
Master

convert to date then take max(field1)

date(Date#(field,'MMM-YY'),'MMM-YY') as field1

Prabhu1204
Creator
Creator
Author

Thank you.. it worked

-Prabhu