I'm trying to create a row format that displays all results in a grid before and including May 31, 2013 in red.

IF(
{Inv Date} <= 31/05/13,
"PastelRedNormal" ,
""
)

I'm doing something wrong with the date but I can't figure it out. Help!

Thanks

Hi Mike,

If you're ever unsure as to formula syntax, check out the help file and the section on formulas. This is in the Date/Time section:
---
DATE(Y, M, D) or DATE(YYYY, M, D)

Description
This function returns the date value corresponding to year Y+1900, month M, and date D. Y must be in the range 0 to 199 (representing 1900-2099). It is less confusing if you use the YYYY form for the year. In this case the YYYY must be a value between 1900 and 2099

Parameters
Y year as a value between 0 and 199
YYYY year as a value between 1900 and 2099
M month
D day
----
Assumig you want May 31, 2013, then the syntax is DATE(2013,5,31)