Date Format mmm-yy

[drew_mcspy]

Hi

The current field "Date" is displayed as dd/mm/yyyy but I'd like to convert it to mmm-yy (e.g. Jul-19 from 01/07/2019).

When I use 

date("Date",'mmm-yy') as Date,

the Date is displayed as 000-19.

There must be a simple way to fix this but I'm not able to see it!

Any help would be appreciated. 

Thanks

[Frank_Hartmann]

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

[drew_mcspy]

Hi Frank

I entered this but it didn't work. The Date just came back as blank.

[wdchristensen · Accepted solution]

You could use the formula below in your app to format the data. 

=date([myDateField], 'MMM-YY')

Alternatively you could use the method described in the link below:

https://qlikviewcookbook.com/2016/07/touchless-formatting/

Date([myDateField], 'MMM-YY') as DateExample

Rwunderlich has a very thorough explanation of what is going on behind the scenes:

https://qlikviewcookbook.com/2017/03/dual-storage-vs-dual-behavior/

[Sameer9585]

Try this?

date(Date,'mmm') & ' - ' & date(Date,'yy') as Date_Feild

this works.😊

[iswarya]

Try this

Date(MonthName(Date),'MMM-YY')

[sunny_talwar]

I would use upper case MMM for months instead of mmm because M is for Months and m is for Minutes

Date("Date", 'MMM-YY') as Date,