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
------------------------------
Original Message:
Sent: 09-11-2019 12:52
From: Lynne8817 Lynne8817
Subject: 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
------------------------------