How do I setup Airtable to update the Due Date field with a date plus one month?

  • 18 July 2023
  • 1 reply

Hi! I have a successful automation of Gsheet-Zapier-Hammock. But how can I set up the field where the date that will be updated to Airtable is plus 1 month?

Details: The field is named Due Date. So the automation will mark the transaction as paid and will create a new record for next month. To do so, I’ll need to create a record copying some of the field data but I cant copy the Due Date field since it should be for the next month already.


Please help. Thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @Mikee 

Good question.

Check out this topic:


Or you can use this Zap action: Formatter > Date & Time > Add / Subtract Time