Convert Date Format

I have this date format

2022-10-01T00:00:00.000-07:00

I want to convert it to just this.

‘August 20, 2022’

How should I do that ?

For me, what works is the following:

Set ‘Column Type’ to “Date → Date and time”
Under ‘Date and time options’ select the ‘Date Format’ format you want. In my case “January 31, 2022”.
Under ‘Time Format’ select “None”.

This should convert to that time format.

1 Like

Max’s solution should work! But you can also just set column type to → Date

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.