Skip to main content
Question

Formula assistance - TODAY function

  • September 11, 2019
  • 0 replies
  • 42 views
Forum|alt.badge.img+11
checkbox [PRE-HANG CKLST] to be checked off when
Today's date is 3 days prior to [projected start date]

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

    Forum|alt.badge.img+12
    • LauraThacker
    • Registered
    • September 11, 2019
    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
    ------------------------------
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    Terms & ConditionsAccessibility statement