Help please. Converting text field with mix of partial dates and friendly dates to ISO date format

Topic Labels: Formulas
743 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, I’m importing data that have “Publish Dates” in a text field.
Most of them are just Month Year (April 2021) some of them are complete (April 30, 2021).
I would like to use the formula field to convert them all to YYYY-MM-DD and use them in calendar/gantt view. It should always default to the 1st of the month for a missing day (i.e. April 2021 will be converted to 2021-04-01)

I tried to search for a way how to use IFs and DATETIME_PARSE but I couldn’t make it work :man_shrugging:

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

This should work:


Substitute {source} for the name of your source field.

You can remove the IF statement if you wish, but leaving it in will cause the formula to yield a blank field instead of an error if the input field is also blank.