Formula assistance - TODAY function
checkbox [PRE-HANG CKLST] to be checked off when Today's date is 3 days prior to [projected start date] ------------------------------ Lynne8817 Lynne8817 ------------------------------
Forum Discussion
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
------------------------------