topic Re: Date Format in QlikView

Date Format

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks,

Daniel

sunny_talwar — Fri, 05 Aug 2016 15:11:00 GMT

May be like this:

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

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

Clever_Anjos — Fri, 05 Aug 2016 15:11:00 GMT

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 — Fri, 05 Aug 2016 16:22:31 GMT

Thanks Sunny,

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

Thanks,

Daniel

Clever_Anjos — Fri, 05 Aug 2016 16:27:29 GMT

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 — Fri, 05 Aug 2016 16:27:52 GMT

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

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