Skip to main content
Question

Automation - Updating Date Field

  • May 4, 2020
  • 0 replies
  • 18 views

Forum|alt.badge.img+7
I am trying to create an automation that will create a new task once a task is completed.  The same task needs to be done every 2 weeks.  When the old task status moved to closed, I would like to copy that record with the same Task Name and Task Analyst and advanced the Due Date to 2 weeks past the Due Date in the old task. 

That's the part I'm having trouble with, not sure how I can tell the automation to modify the Due Date field of the new record to a date that is 14 days in the future of the date in the previous Due Date.


Any assistance would be greatly appreciated.

------------------------------
Stephanie
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,
just make a formula date field called [Next Due Date].

The formula will be

[Due Date] + Days(14)

Then use that  field in the Automation.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------