Formula for a date 2 weeks previous
Hi, I have a formula-date field to get a date a month before: AdjustMonth(ToDate(ToText([Start Date])), -1) I would like to have a date that is only 2-weeks before [Start Date]. Any thoughts? ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendTry 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__YouQrew Legend
Qrew LegendNote, 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
------------------------------
- Hey 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__YouIndeed 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
------------------------------- Thank 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
------------------------------
