- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 05:42 AM - edited ‎Mar 16, 2023 06:29 AM
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:
- 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)
- 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.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 07:58 AM - edited ‎Mar 16, 2023 08:06 AM
Solved it:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 07:42 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 16, 2023 07:58 AM - edited ‎Mar 16, 2023 08:06 AM
Solved it:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 18, 2023 01:57 PM
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.
