Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoTry this
AdjustMonth([Start Date]), -2)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
AdjustMonth([Start Date]), -2)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
MarkShnier__You
Qrew Legend
6 years agoNote, I edited the above after posting to -2.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- RyanStanford16 years agoQrew CaptainHey Mark,
The OP is asking for 2 weeks prior to [Start Date], if I'm reading your answer right, wouldn't that be two months prior to [Start Date]?
------------------------------
Ryan Stanford
------------------------------- MarkShnier__You6 years ago
Qrew Legend
Indeed you are correct. Should be.
[start date] - Weeks(2)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- RachelCohen16 years agoQrew TraineeThank you both.
I now have a 2 weeks prior date, and a check box I’m hoping to use as a trigger for a reminder or a notification (preferred). Is there a way to use the checkbox as a trigger even if the record is not modified? I hope that makes sense.
Rachel
Sent from my iPhone
------Original Message------
Indeed you are correct. Should be.
[start date] - Weeks(2)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------