Hi guys,
As you can see I work with a formula.
And I don’t get my(?) fault, why this formula in recordline no. 8 isn’t working as well as in the other lines …
Anyone an idea? :thinking:
Thank you in advance and best regards
Martin
Creating Dates: Where is the formula counting an additional hour?
+3
+29Welcome to the Airtable community!
It’s probably a timezone issue.
Check the formatting options for both the formula field and the initial date field. Make sure that they are either both set to local time or both set to GMT.
+3Welcome to the Airtable community!
It’s probably a timezone issue.
Check the formatting options for both the formula field and the initial date field. Make sure that they are either both set to local time or both set to GMT.
Thank you.
But how should this be possible, if the formula or the timezone issue has got an impact on the whole column?
Only one row is wrong …
If this is a “correct and logical fault”, there must be something to change just one row or just one field, right?
It is crazy.
If I am in the formula of Kontrollfeld, Beginn, go to formatting, klick Use the same time zone (GMT) for all collaborators the whole column is one hour behind Uhrzeit, Beginn der Veranstaltung. Fine.
But if I click Use the same time zone (GMT) for all collaborators in that formula again, all fields in that column are working – except that single field, that adds one hour …
+29Thank you.
But how should this be possible, if the formula or the timezone issue has got an impact on the whole column?
Only one row is wrong …
If this is a “correct and logical fault”, there must be something to change just one row or just one field, right?
It is crazy.
If I am in the formula of Kontrollfeld, Beginn, go to formatting, klick Use the same time zone (GMT) for all collaborators the whole column is one hour behind Uhrzeit, Beginn der Veranstaltung. Fine.
But if I click Use the same time zone (GMT) for all collaborators in that formula again, all fields in that column are working – except that single field, that adds one hour …
Can you post the formula?
+29This is very strange. Try editing the duration field to something different to force the formula field to recalculate. Then edit the duration back. If editing the value of the duration field does not cause the formula field to recalculate, contact support.
+3This is very strange. Try editing the duration field to something different to force the formula field to recalculate. Then edit the duration back. If editing the value of the duration field does not cause the formula field to recalculate, contact support.
No, doesn’t work neither.
Anyway, thank you for trying to help me.
I just wrote to the support.
+3This is very strange. Try editing the duration field to something different to force the formula field to recalculate. Then edit the duration back. If editing the value of the duration field does not cause the formula field to recalculate, contact support.
The support found out:
On the 27th of march is a change of summer-/wintertime … :stuck_out_tongue_winking_eye:
So have that in mind, if you are calculating dates.
+29The support found out:
On the 27th of march is a change of summer-/wintertime … :stuck_out_tongue_winking_eye:
So have that in mind, if you are calculating dates.
Thank you so much for coming back and posting the resolution!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.