Discussion board where members can get started with QlikView.
I've a simple question (I hope) ,
How can I convert a date, with the month name in it?
For example I the following data:
I used the following expression to achieve this:
date(Date#(date, 'DD-MM-YYYY hh:mm:ss'),'DD') & '-' & Month(date) & '-' & year(date)
I was just curious whether I could use a simpler expression
Thanks in advance!
Go to Solution.
Have a look at the format codes in the Help, please, I think you can use something like
date(Date#(date, 'DD-MM-YYYY hh:mm:ss'),'DD-MMM-YYYY')
I did, but appreatly not good enough.
I knew that in Excel 'MMM' would return the month name, but wasn't sure whether QV would do the same. Should have tried it before posting a question on the forum.
Like always, many Thanks for you help!