Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Anonymous
Not applicable

Find min and max date with format MM/YYYY

Hello qlikers 🙂 ,

I want to find the min date and the max date of a column with the format MM/YYYY. 

How can I do that? Thank in advance! 🙂

Labels (3)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Assuming your date field is text, you can try like:

Date(Max(Date#(YourDateField, 'MM/YYYY')), 'MM/YYYY')

View solution in original post

2 Replies
Highlighted
MVP
MVP

Assuming your date field is text, you can try like:

Date(Max(Date#(YourDateField, 'MM/YYYY')), 'MM/YYYY')

View solution in original post

Highlighted
Anonymous
Not applicable

Thank you very much for the quick solution!