Skip to main content

I just started using Airtable and I'm trying to remove the date/time from a column or create a new column that has the date/time removed with just the remaining text. The column is linked to another airtable and it is using the primary field, so I don't think I can change it from there. 

For example, in the column it will have-

2023-09-20T00:00:00.000Z Opinion on Policy

2022-10-03T00:00:00.000Z Environmental Needs

I want to removed the date and time and have the column say-

Opinion on Policy

Environmental Needs

Thanks for the help!

 

Hi,
Use formula with text functions. There are some examples in docs. When you need to change some text pattern, use SUBSTITUTE, and when a given number of chars, use REPLACE. In your example, if it's ISO-formatted date/time, it should have the same length in all rows, so REPLACE({Field},1,25,"") will do the job.
You can use RIGHT({Field},LEN({Field}) - 25) as well

Reply


Terms & Conditions