
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date Format mmm-yy
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
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
date(date#(Date,'DD/MM/YYYY'),'MMM-YY') as Date

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Frank
I entered this but it didn't work. The Date just came back as blank.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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/

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this?
date(Date,'mmm') & ' - ' & date(Date,'yy') as Date_Feild
this works.😊

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Date(MonthName(Date),'MMM-YY')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
