Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When i tried to convert the date into MMM-YY format, i am getting the results as below. please let me know how to get it in MMM-YY format.
date(R_MonthYear,'MMM-YY')
Date(MonthYear,'MMM-YYYY')
Hi,
Try date#(DATEFIELD,'DD-MM-YYY') as Datefield.
Hope this helps
Best Regards,
Gabriel
HI
Try like this
date(R_MonthYear,'MMM-YY')
But what is original format of R_MonthYear? is in correct date format? if not, use
suppose R_MonthYear is in MMMDDYYYY, then use like below
date(date#(R_MonthYear,'MMMDDYYYY'),'MMM-YY')
hope it helps