Skip to main content

Record template current date adds 3 days


Forum|alt.badge.img+2

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.

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+28

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


Ramosh
Forum|alt.badge.img+5
  • New Participant
  • 2 replies
  • January 23, 2025

Might be that your relative date settings exclude Saturdays and Sundays.

 

 


Reply