Date Formatting

[jlfromm]

I have a date in my excel file as YYYY-MM-DD and I need to convert it to MM-DD-YYYY how do I do this

[binuacs · Accepted solution]

@jlfromm  DateTimeFormat([Date],'%m-%d-%Y') should work

[jlfromm]

another question if I have a date in some of the cell and some cells say "na" or Other Notes which i need those notes to stay in that cell

 After I put this formula in then in those cell I get 

[Christina_H · Accepted solution]

You need to check whether the original data is a valid date.  Here are some options:

if IsNull(DateTimeFormat([Next review],'%m-%d-%Y')) then [Next review] else DateTimeFormat([Next review],'%m-%d-%Y') endif

if REGEX_Match([Next review], "\d{4}-\d{2}-\d{2}") then DateTimeFormat([Next review],'%m-%d-%Y') else [Next review] endif

This one won't return conversion errors since it checks the format first.