Create Pre/Post Field from Calculation based on Current Date

Question & Answer
1

Hello,
I am trying to create a field for “Pre or Post” the current date. My goal is to have a field that I can then use for conditional formatting my charts to sort actual data from plan data adding by gray to data dates that haven’t been completed.

I am trying to find proper calculation format for

if DATE < Current date then “Pre” else “Post”

I have a date field to work with but am not sure how I would distinguish CURRENT DATE in a calculation.

Help is very appreciated

2

you can use the now() function.