Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See this blog post: Get the Dates Right
Prox,
Use Date([FieldName],'MM/DD/YYYY')
See this blog post: Get the Dates Right
Gysbert,
Thanks for sharing HC's date post.
date(Myfield,'DD-MMMM-YYYY')