Forum Discussion

BuildPro's avatar
BuildPro
Qrew Captain
6 years ago

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

1 Reply

Sort By
  • Laura_Thacker's avatar
    Laura_Thacker
    Qrew Commander
    6 years ago
    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
    ------------------------------