Conditional formatting - dates in January

[sdjames1979]

Hi there

I have a report and i'm trying to set up the conditional format to highlight any dates within January red.

Thanks

S

 

[vbaInet]

January in any year?

[I][COLOR="Blue"]Expression Is[/COLOR][/I]

Month([DateField]) = 1

January in current year?

[I][COLOR="Blue"]Expression Is[/COLOR][/I]

Format([DateField], "mmyy") = Format(Date(), "mmyy")