Skip to main content

Hello,

I am having a table in Airtable that contains a text field with dates. I imported a CSV files. And all dates were added as text field in a wrong format (MM/DD/YY). 

So I am basically looking for a way to: 

  1. Convert these text date field to a real date field that is next to the column (so Column 1 with the text based date value should be copied to Column 2 with a date field)
  2. And in another column I want to change the date format (also text based) from MM/DD/YY to DD/MM/YYYY.

How can I do this? 

Thanks for help, 
M.

I figured it out by adding a formula field and: 
DATETIME_PARSE({Name of Text Date Field}, 'MM/D/YY')

But the problem is that some cells don't have a text based date and in output of the formula field there will be #ERROR!. 

How can I run the formula only if there is a value available in the text based date field? Is there something like a "IF…" command?

I figured it out by adding a formula field and: 
DATETIME_PARSE({Name of Text Date Field}, 'MM/D/YY')

But the problem is that some cells don't have a text based date and in output of the formula field there will be #ERROR!. 

How can I run the formula only if there is a value available in the text based date field? Is there something like a "IF…" command?


Solved it: 

IF({Name of Text Date Field}, DATETIME_FORMAT({Name of Text Date Field}, "DD.MM.YYYY"), "")

What if you'd like to include the time? I have the same issue and i'd like to keep the time that was imported after the date in the same cell. 

Reply


Terms & Conditions