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 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
------------------------------
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
------------------------------- MarkShnier__YouA notification will only fire when a record is being added or edited or deleted.However you can explore the use of both Subscriptions and Reminders. Either of these will fire through the simple passage of time.
Note that subscriptions and reminders will only fire to users unlike notifications which can be figured as open notifications and can fire to any email address.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
