Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
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:
originaldate | correctly formatted |
---|---|
1-1-2012 0:00:00 | 01-jan-2012 |
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!
Carter
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')
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')
Hi Stefan,
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!
Carter