I need code for 30 days prior to a specific date in a report

[SuePee]

I have an executive report that the header bar changes color if the contract deliverable is on-time, green, late to contract, Red and if the contract has been modified for a specific item it turns orange.

Now my boss would like to see it change to yellow if the delivery date is within 30 days. I have done all the changes with code for the header bacground. But I do not know how to write the code that will equal "Now - 30 days"

Thanks for any help you can give.

 

[dhookom]

Please share your current code and the name of the text box containing the delivery date.

Duane
MS Access MVP

 

[cghoga]

the code to get "Now - 30 days" is "Now()-30".

but to get whether the delivery date is within 30 days wouldn't you need to say delivery date - Now() and if the result is <30 change to yellow?

sorry if i'm no help.