Forum Discussion
Laura_Thacker
6 years agoQrew Captain
Formula Checkbox:
Formula:
Today() >= ( [Projected Start Date] - Days(3) )
This will leave the box checked once today's value is equal to or greater than 3 days before Projected Start Date.
If you only want the checkbox to trigger on a single day (for example to trigger a reminder or subscription report) then change it to this:
Today() = ( [Projected Start Date] - Days(3) )
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------
Formula:
Today() >= ( [Projected Start Date] - Days(3) )
This will leave the box checked once today's value is equal to or greater than 3 days before Projected Start Date.
If you only want the checkbox to trigger on a single day (for example to trigger a reminder or subscription report) then change it to this:
Today() = ( [Projected Start Date] - Days(3) )
------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------