Skip to main content

Remove date/time from field

  • November 30, 2023
  • 1 reply
  • 28 views
J
Forum|alt.badge.img+2
  • JJJ
  • New Participant

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

Alexey_Gusev
Forum|alt.badge.img+25

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

J
Terms & ConditionsAccessibility statement