Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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/
date(date#(Date,'DD/MM/YYYY'),'MMM-YY') as Date
Hi Frank
I entered this but it didn't work. The Date just came back as blank.
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/
Try this?
date(Date,'mmm') & ' - ' & date(Date,'yy') as Date_Feild
this works.😊
Try this
Date(MonthName(Date),'MMM-YY')
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,