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

[Bryan_Smith]

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

[Bryan_Smith]

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.

[Alexey_Gusev]

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.

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.