Max of Date

[rxp03570]

Hi,

I have a date field in the format 'JAN-2018', here I want to take the Max of date available. I tried using Max(Field1) but I don't get any output.

Any suggestions.

Thanks,

[dplr-rn]

Did you check the data type of the field in data model viewer? Maybe a data type issue

[vamsee · Accepted solution]

Try

     Date(Max(Date#(Field1, 'MMM-YYYY')))