Record template current date adds 3 days

379 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am using record templates to create deliverables and tasks. I am setting due dates relative to the "current date".  For example, I want the deliverable to be due "1 day after current date". When the template runs, it adds 3 days to the current date. If the current date is 6/30/23, it will put the due date as 7/3/23 rather than 7/1/23. If I use current date alone, it puts in today's date.

Screenshot 2023-06-30 at 2.19.26 PM.png

Does anyone know why this is happening and how to prevent it? 

1 Reply 1

Hmm, I feel like this might be a weird interaction with your timezone, how Airtable deals with timezones and the various field displays.  I would suggest experimenting with the time zone displays for the fields, and perhaps opening a ticket with Airtable support to see what they might suggest about your situation