+2Given:
Result: when within the UTC-5 window (i.e. after 7pm) the displayed date defaults to the next day.
There MUST be away to make this work correctly - yes?
Best answer by leok
Hi
Two things that can work for now:
Option 1 - Formula field
Instead of using the Default Current Date field as a Date field, create a formula field and type Default Current DT in it. After doing this, you will be able to select your timezone again. This is probably the easier option since it does not use any of your automation quota.
Option 2 - Automation
You can create an automation that runs when a new record is added and writes today's date into the field at that moment. This works well but it does use one automation run each time.
I would try the formula field first.
Also, it would be worth submitting this as a product idea so the Airtable team can see it. They do check that page and it helps them understand what people actually need. You can do that here: https://community.airtable.com/p/product-ideas
Hope this helps.
Leo
+31Hm, could you provide some screeenshots of your field setup?
When you said ‘Set to local time’, I was thinking you were talking about ‘Use the same time zone for all collaborators’, but if a Date field doesn’t have ‘Include time’ toggled on I can’t set a time zone for it at all so I figure I’m not understanding something
Toggled off:
Toggled on:
+2So this image shows my test table. The field “Real Text Time” is just a manual entry reflecting the date-time that I added a record.
This the field settings for “Default Current Date”
+2Hi
Two things that can work for now:
Option 1 - Formula field
Instead of using the Default Current Date field as a Date field, create a formula field and type Default Current DT in it. After doing this, you will be able to select your timezone again. This is probably the easier option since it does not use any of your automation quota.
Option 2 - Automation
You can create an automation that runs when a new record is added and writes today's date into the field at that moment. This works well but it does use one automation run each time.
I would try the formula field first.
Also, it would be worth submitting this as a product idea so the Airtable team can see it. They do check that page and it helps them understand what people actually need. You can do that here: https://community.airtable.com/p/product-ideas
Hope this helps.
Leo
+2Okay, thanks. The formula does work. So that’s good.
But I have tried using an automation and that didn’t work…
+2Automation should work too. If you share your AutoDate field setup, I can help figure out what went wrong. If not, no worries, you’re welcome!
+2Hi
This really seems like something Airtable needs to fix on their end. It would be worth submitting it here so the team can see it: https://community.airtable.com/p/product-ideas
Leo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
