Find min and max date with format MM/YYYY

[Anonymous]

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! 🙂

[tresesco · Accepted solution]

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

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

[Anonymous]

Thank you very much for the quick solution!