Date format MMM-YY to DD/MM/YY?

[#1]

Hi, could someone help me out with this please? I have dates in my data in the format MMM-YY i.e. Aug-14 in text format. I'm trying to convert it to DD/MM/YY with the below MakeDate butnot sure what to put in the "Month" part to make it work?

MakeDate(num(20 & right(Date,2)),?,'01')

Any suggestions orr alternatives to create the date?Many thanks.

[Anonymous · Accepted solution]

date(date#('Aug-14','MMM-YY'),'DD/MM/YY')

[tresesco]

Try like:

Load

          Date(Date#(DateField, 'MMM-YY'), 'DD/MM/YY') as NewDate

[PrashantSangle]

Hi,

You can try like this also

Makedate(Year(date#('Aug-14','MMM-YY')),Month(date#('Aug-14','MMM-YY')),'01')

Regards

[MayilVahanan]

Hi

Try like this

Load *,

Date(Date#(DateField, 'MMM-YY'), 'DD/MM/YY') as Date

from tablename;

or

Makedate(Year(date#(DateField,'MMM-YY')),Month(date#(DateField,'MMM-YY')))

[MK_QSL]

=Date(Date#('Aug-14','MMM-YY'),'DD/MM/YYYY')

or

=Date(Date#(YourFieldName,'MMM-YY'),'DD/MM/YYYY')

[#7]

Thank you all! Much appreciated!