Jump to content
We've recently updated our Privacy Statement, available here. ×

Specific date for expression, instead of DateTimeNow

Anthony stark

Recommended Posts

Hi Guys,

I am trying to modify the expression below to be 14-APR-20 instead of DateTimeNow, how do i rewrite this expression to do this so intead of DateTimeNow, i want the specific date of 14-APR-20

Thanks in advance

CASE WHEN ([PREPAREDATE]>DateAdd("dd",999,DateTimeNow())) or ([PREPAREDATE]

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...