I am attempting to use Conditional Formatting on a Sub-Form that I have with a concatenation of two fields - month & year and hardcoding 1 as the day so it is like this
Code:Date([Month] & "/01/" & [Year]) As InvoiceDate
Now on my form I want to use an expression to
Turn Red if the InvoiceDate is >= 60 days of the 1st of the current month
Turn Yellow if the InvoiceDate is between 30 days and 60 days of the 1st of the current month
I Have tried
Expression: [InvoiceDate] < Date()-60 .... for Red
Expression: [InvoiceDate] Between Date()-30 And Date()-60 ....for Yellow
BBBUUUUTTTT this takes into account the current date and not the 1st of the month, so my coloring is skewed. I tried to use DateSerial() in my Expression but then NOTHING is colored, almost like the Conditional Formatting does not recognize it. I'm at a loss at this point!