Specific date for expression, instead of DateTimeNow

[Anthony stark]

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]

[Kirsten Smith (she/her)]

You should be able to use:

 

Date(2020,4,14)

 

to get this specific date.

[Anthony stark]

Hi Kristen

 

How do i fit that into the expression after removing the DateTimeNow Its giving me an error

[Kirsten Smith (she/her)]

This is what I used to confirm formatting, you'll need to add your column name back in:

 

CASE WHEN ([Date]>DateAdd("dd",999,Date(2020,4,14))) or ([Date]

[Anthony stark]

Thanks Kirsten, this worked