Help

How to bulk update (or search and replace) the time but not the date in a date field.

1106 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bryan_Smith
6 - Interface Innovator
6 - Interface Innovator

I have a View of records with populated date fields.  Is there a way to change all the times so that all the times are 5:00pm while keeping the same date?  I only want to do this to a view of records in the table, not the entire table.

June 4, 2023 12:00am
June 11, 2023 12:00am
June 18, 2023 12:00am
June 25, 2023 12:00am
July 2, 2023 12:00am

2 Replies 2
Bryan_Smith
6 - Interface Innovator
6 - Interface Innovator

So far it's Notepad ++  (copy range, paste in notepad++, search & replace, paste back to airtable ) for the win!  Goggle sheets was problematic with changing the date text slightly.

 

Hi
Use new field with dateadd formula.
If the result is different from expected, ensure that format settings is the same including 'use same timezone for all collaborators' option. in my table it switched off.

Alexey_Gusev_0-1685209909346.png

In your view, copy-paste whole column from new to old. If you worry about data of all table, duplicate the field and do a try on it.