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
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
------------------------------
[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
------------------------------
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
------------------------------
- A 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
------------------------------
