Solved Conditional Formatting Expression Data Format Error

[Kayleigh]

Hi
I have just encountered an issue that have not found previously.
When designing conditional formatting rules for date fields it would change the expression to date format even though I input as regular integer. I tried a couple of times and this was result.
See attached screenshot.

 

[cheekybuddha]

Try placing a equals sign at the beginning of your expression

 

[Kayleigh]

Tried but getting invalid syntax.
Expression is: [TotalDue]<0.01

 

[cheekybuddha]

OK, that's a weird one! Happens in Acc 2007 too.

Change your expression to:
Expression is: [TotalDue]<CDbl(0.01)
Or:
Expression is: [TotalDue]<Val(0.01)

 

[Kayleigh]

Wow that sorted it! Thanks

 

[cheekybuddha]