Help

Re: Remove date/time from field

744 0
cancel
Showing results for 
Search instead for 
Did you mean: 
JJJ
4 - Data Explorer
4 - Data Explorer

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!

 

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars

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