Skip to Content
0

Suppress a row using a Formula

Dec 08, 2017 at 04:20 PM

31

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Dec 09, 2017 at 07:51 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded