Push Dates Forward

Push Dates Forward

Master Tag
Tips & Tricks
Created
Jun 24, 2021 06:40 PM
Usage
dateAdd
toNumber
Web Tags
Database
Formula
Alternatives
Cover
Untitled_Artwork 2.png
In the example below, everytime a checkbox is ticked, the original date is pushed 3 days. This will only occur at a maximum 3 times with a 9 day gap. Of course, you can add more checkboxes and alter the space between each repetition via a simple formula.
Date Pushing
Name
Date
Session 1
Session 2
Session 3
Next Review
Jun 22, 2021
Session 1
Session 2
Session 3
Jun 20, 2021
Session 1
Session 2
Session 3
Jun 25, 2021
Session 1
Session 2
Session 3
Jun 29, 2021
Session 1
Session 2
Session 3
if(prop("Session 3"), dateAdd(prop("Date"), 9, "days"), if(prop("Session 2"), dateAdd(prop("Date"), 6, "days"), if(prop("Session 1"), dateAdd(prop("Date"), 3, "days"), prop("Date"))))
 
Alt → Date Pushing With Select
Name
Date
Session 1
Session 2
Session 3
Next Review
Jun 17, 2021
1 day
1 day
4 days
Jun 18, 2021
4 days
4 days
1 day
Jun 23, 2021
4 days
7 days
1 day
Jun 18, 2021
4 days
7 days
7 days
Jun 22, 2021
4 days
7 days
7 days
Jun 29, 2021
1 day
7 days
4 days
Jul 1, 2021
1 day
7 days
7 days
dateAdd(prop("Date"), toNumber(prop("Session 1")) + toNumber(prop("Session 2")) + toNumber(prop("Session 3")), "days")