Skip to Content

Suppress a row using a Formula

I would like to write a formula that will suppress a row if the DischDate was within the hour after the Administration Time. Is this type of formula possible ? See attached screenshot.

capture.jpg (17.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 09, 2017 at 07:51 AM

    Hi Curt,

    If both DischDate and Administration Time are 'Date Time' fields, you could use the following conditional suppression formula for the section:

    DateDiff('s', {Administration Time}, {DischDate}) <= 3600

    P.S: You could also add this to the Record Selection Formula

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded