Date in MMM-YY fromat.

[#1]

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.

[#2]

date(R_MonthYear,'MMM-YY')

[nizamsha]

Date(MonthYear,'MMM-YYYY')

[Gabriel]

Hi,

Try date#(DATEFIELD,'DD-MM-YYY') as Datefield.

Hope this helps

Best Regards,

Gabriel

[MayilVahanan]

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