Need simple timestamp-related calc, please

[Rich S]

I've tried a number of permutations to get this to work but I just can't seem to nail this one.

I have a TimeStamp field ("TimeStamp") and a Get(CurrentDate) date field ("CurrentDate"). I need a Case statement calc to test if 90 days has elapsed since the TimeStamp date; if so, a blurb of text should appear; if not, nothing.

What's that syntax for this calc?

Thanks!

Rich

[Rich S]

Ah! Got it.

Case ( Get ( CurrentDate ) - GetAsDate ( Timestamp ) > 90; "good cop"; "bad cop--no donut")

[LaRetta]

Your original post said you wanted nothing displayed if not 'good cop.' If this is true then you can forget about creating a calculation at all (which is important in keeping down the number of field clutter).

You would use conditional format. Create the words "good cop" in black. Conditional format calculation would be: Get ( CurrentDate ) - GetAsDate ( timestamp ) ≤ 90

... and change the text color to be same as your background color. It will then disappear completely if "bad cop - no donut" :wink2:

[Rich S]

Thanks, LaRetta: I was working from a test file and goofing off a little more than I should; the "bad cop--no donut" text was supposed to be double-quoted to leave the field empty...though the conditional formatting idea is a good one to keep in mind, too!