Date in text format with Long Month Name

[mazacini]

I am trying to load an excel file with dates in following text format: 2012 September 28.

How can I convert this to date number 41180?

[Gysbert_Wassenaar · Accepted solution]

date#(MyDateField,'YYYY MMMM 28') + 27 as MyDateField

date#('2012 September 28','YYYY MMMM 28') is 41153 so add 27 to get 41180

Just kidding, but you get the idea I hope.

[mazacini]

Thank you Gysbert.

I have a number of different dates. So I changed your suggestion slightly to:

Date# (Date,'YYYY MMMM DD') as Date

Works great!