Two Different Date Formatts In A Field

[#1]

I have a field that contains two different date type.  They are as follows:

MM/DD/YYYY HH:MM:SS

M/D/YYYY HH:MM:SS

I want to remove the HH:MM:SS.  Typically, I would use LEFT(MyDate, 10) for the MM/DD/YYYY HH:MM:SS.  But since I have the two formats this does not work because for the dates in  M/D/YYYY HH:MM:SS the LEFT(MyDate, 10) will pull in the first "H" into my new date.  How do I convert these two formats into on date format of MM/DD/YYYY? 

Thanks in advance for your help

Brian

[onetwothree123]

Prox,

Use Date([FieldName],'MM/DD/YYYY')

[Gysbert_Wassenaar · Accepted solution]

See this blog post: Get the Dates Right

[onetwothree123]

Gysbert,

Thanks for sharing HC's date post.

[nizamsha]

date(Myfield,'DD-MMMM-YYYY')