Discussions

 View Only
  • 1.  Formula assistance - TODAY function

    Posted 09-11-2019 12:53
    checkbox [PRE-HANG CKLST] to be checked off when
    Today's date is 3 days prior to [projected start date]

    ------------------------------
    Lynne8817 Lynne8817
    ------------------------------


  • 2.  RE: Formula assistance - TODAY function

    Posted 09-11-2019 12:58
    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
    ------------------------------