Date Format

[danielnevitt]

Hi,

Please can someone advise how I can convert a date from format mm-dd-yyyy to MMM-YY?

Thanks,

Daniel

[sunny_talwar]

May be like this:

Date(MonthStart(DateField), 'MMM-YY') as MonthYear

or

Date(MonthStart(Date#(DateField, 'MM-DD-YYYY')), 'MMM-YY') as MonthYear

[Clever_Anjos]

If your field is a date formatted as mm-dd-yyy you can use

Date(MonthStart(yourfield),'MMM-YY')

If you have a string with mm-dd-yyyy

Date(MonthStart(Date#(yourfield,'MM-DD-YYYY')),'MMM-YY')

[danielnevitt]

Thanks Sunny,

Is it possible to change to capitals ie JAN-17 rather than Jan-17?

Thanks,

Daniel

[Clever_Anjos]

Change this variable into your script as you want

SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez';

[settu_periasamy · Accepted solution]

you can try with Upper function like (using stalwar1‌ expression)

Upper(Date(MonthStart(Date#(DateField, 'MM-DD-YYYY')), 'MMM-YY')) as MonthYear