Date Conversion

[ramanarayan]

stalwar1‌

Hi Sunny Talwar/Experts,

I have the month/year in the following format in the raw data that i load. I need help with a formula which should pick the max of the Month_Year. since the data is not in the specified format, date function is not working.

Please help.

Appreciate your support

Thanks,

Ram

[olivierrobin · Accepted solution]

hello

I would try something like :

=max(date(date#(Month_Year,'MMM''YY'),'MM/YYYY'))

[jaumecf23]

Hi,

Try this formula:

=Date(max(Date#(Month_Year,'MMM'&Chr('39')&'YY')),'MM/YYYY')

[ramanarayan]

Thank you Olivier. Perfectly works

Appreciate it

[jonathandienst]

=Date(Max(Date#(Month_Year, 'MMM''YY')), 'MM/YYYY')

Although these would be simpler if they were converted to dates when loaded

LOAD ....

     Date#(Month_Year, 'MMM''YY') as Month_Year,

     ...

[ramanarayan]

Thank you Jonathan. This also works