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__You6 years ago
Qrew Legend
Note, 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
------------------------------- 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
------------------------------