Skip to main content

Hello everyone,

Any clarity or information on this time and date issue would be awesome!

I have 2 tables which are linked through a record. In each table, I have a formula field which produces a date. I need the dates to match. Unfortunately, the formulas are not the same. One is based on a date field in the first table and is a dateadd formula. In the second table, it is a createdtime formula. On the first day of operations, the date is submitted through a form to the date field in the first table. The formula field in the first table adds one day to this date so that process which happen on the second day are kept track of. In the second table which keeps track of the processes which happen on the second day of operations, I have the createdtime field. I need this field to match the dateadd field so that I can automatically link the records. However, something is happening with the formulas such that they are not the same day when I want them to be. Does anyone know how to fix this?

I have added some photos of the situation. Unfortunately, I cannot turn the time off because then it wouldn’t be in the correct time zone. The createdtime field is always created 1 day after the production date and should match the dateadd field which adds 1 day to the production, yet it does not do this.

 

In your CREATEDTIME() Slicing Date formula (3rd screenshot) have you checked the formatting to ensure it’s using PDT/PST rather than UTC? Airtable loves to put stuff in UTC and most of the time if computed dates aren’t lining up it’s some kind of timezone problem.

Thanks for responding! Unfortunately, yes, I have checked that the time zones are all the same.

Hmm… not precisely clear exactly how all these fields interconnect after reading the post a couple times, but two other potential troubleshooting ideas…

  • Have you tried DATEADD({Production Date}, 24, “hours”) using hours instead of days? 
  • You could always add another formula using DATETIMEFORMAT to remove the time after you’ve confirmed the right date

Hi,

 

That’s part of the issue: There are 2 different formulas which should produce the same date based on our operational practices. However, due to specifying the time (because I need them to be on the same time zone), then the dates don't end up matching because the times do not match exactly.

 

Thank you for both suggestions - I will try that.

Hmm, any chance you could recreate this issue in a separate, simplified base and provide access to it?

Terms & Conditions