formatting date 1-1-2012 to 1-jan-2012

[#1]

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

[swuehl · Accepted 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')

[#3]

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