:chomp:
I am trying to get fields highlighted when they are due. In my report I have dates listed by month they have been on stability. I need to highlight the date when the month/year is current. Example in the report the 12 Month column is all due in Oct of 2005, I would like for it to be yellow to designate it different from the other date columns. I have tried the conditional formatting with:
field value is between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date()),31)
This works well for everything, except that it is not specific to the current year only. It will pull dates in Oct 2006 as well.
I would also like to generate a report that will use a similar filter to add to my queries that would only print the due dates. I can insert this same code, but need to refine it to only show the month due, not every pull date for the particular record. So on a new report I can have Lot XYZ with pull dates for only 12 Month, which is the current month.
Thoughts?
Please help, I am in a time cruch.
Thanks.
I am trying to get fields highlighted when they are due. In my report I have dates listed by month they have been on stability. I need to highlight the date when the month/year is current. Example in the report the 12 Month column is all due in Oct of 2005, I would like for it to be yellow to designate it different from the other date columns. I have tried the conditional formatting with:
field value is between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date()),31)
This works well for everything, except that it is not specific to the current year only. It will pull dates in Oct 2006 as well.
I would also like to generate a report that will use a similar filter to add to my queries that would only print the due dates. I can insert this same code, but need to refine it to only show the month due, not every pull date for the particular record. So on a new report I can have Lot XYZ with pull dates for only 12 Month, which is the current month.
Thoughts?
Please help, I am in a time cruch.
Thanks.