This content has been marked as final. Show 2 replies
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!