Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
Could you please help with the below scenario
I have a month filed with the values Jan-2021,Feb-2021,..... Jan 2022
I am facing challenges in formatting in taking minimum and maximum month year.
Could anyone suggest a right way ?
convert to date then take max(field1)
date(Date#(field,'MMM-YY'),'MMM-YY') as field1
convert to date then take max(field1)
date(Date#(field,'MMM-YY'),'MMM-YY') as field1
Thank you.. it worked