Formula for all columns with dates

[calvincarr29]

How do you write the following formula?

"If any of the columns contains a date then format it as mm-dd-yyyy."

 

[flying008 · Accepted solution]

Hi, @calvincarr29 

FYI.

Change Output type to 'V-String' .

DateTimeFormat(ToString([_CurrentField_]),'%m-%d-%Y')

[calvincarr29]

Thank you so much!