Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hello
I would try something like :
=max(date(date#(Month_Year,'MMM''YY'),'MM/YYYY'))
hello
I would try something like :
=max(date(date#(Month_Year,'MMM''YY'),'MM/YYYY'))
Hi,
Try this formula:
=Date(max(Date#(Month_Year,'MMM'&Chr('39')&'YY')),'MM/YYYY')
Thank you Olivier. Perfectly works
Appreciate it
=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,
...
Thank you Jonathan. This also works