Hello. I have this date in American format, I need to convert it to Latin American format, without the time.
5/14/1935 12:00:00 AM
I tried with the text function, with the dateFormat function and neither of them gives me the expected result, even with the dateFormat function the date changed to June 6, 1936, which should not be the case
I need it to return a date that says 5/14/1935 or else May 14, 1935
What's wrong with just using Text(date, DateTimeFormat.ShortDate)
What result are you getting?
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.