Conditional formatting - Date diff

[Gismo]

Hi all,

Hope all is well

I want to highlight when the requirement date is less then 6 days from now
I used the below conditional formatting formula but not working as I thought it would

DateDiff("d",[Reqmt Date],Now())<6

 

[CJ_London]

In what way is it not working?

 

[bob fitz]

Try
DateDiff("d",Now(),[Reqmt Date])<6

 

[Gasman]

Hi all,

Hope all is well

I want to highlight when the requirement date is less then 6 days from now
I used the below conditional formatting formula but not working as I thought it would

Why not just test it in the Immediate Window?

? datediff("d",#09/10/2022#,date) < 6
True

So show your conditional formatting

 

[Gismo]

Thank you
Looks great

 

[Gasman]

Thank you
Looks great

I would be careful about that? That is why I test when I can in the immediate window.

 ? datediff("d",now(),#09/10/2022#)
-4