datediff in conditional formating

[lotarugg]

Hi, I'm trying to use an expression in conditional formatting on a date field. I want the date to turn red if it is more than 18 workdays older than today's date (now).

I'm using

DateDiff("d",[Date_Received],[Now()]) > 18
Not working though
Thanks

 

[apr pillai]

Change to : DateDiff("d",[Date_Received],Now()) > 18

Remove the [] from around the Now() Function.

 

[lotarugg]

That works great thanks. I forgot I need another date field to be blank for the expression to be true. I have added this to the end of the expression but no good
AND [Acknowledge_date ] = isnull

 

[gemma-the-husky]

note that workdays is not the same as days.

I think you will need a purpose built function to determine the number of workdays, and then you can use conditional formatting to test the that number

 

[lotarugg]

Thanks. What about

DateDiff("d",[ Date_Received],Now()))-(DateDiff("ww",[ Date_Received], Now()))*2)>18 AND ([Date_Acknowledge]) = IsNull
??

 

[boblarson]

Get rid of the equals sign and add a space and you don't need the extra parens:

AND [Date_Acknowledge] Is Null

 

[lotarugg]

Beautiful, it works

Many thanks