Working with Dates in forms

[SFCMatthews]

Working with 2007 MS Access. I need help with forms and conditional formating dates. I have a qual_date field that has a 6mth window. Anything older than 6mths needs to be highlighted in red. Is there is an exp I can use in the drop down menu. Thank you for your help!

 

[Alansidman]

Here is information on conditional formatting.

http://office.microsoft.com/en-us/a...using-conditional-formatting-HA010208133.aspx

 

[SFCMatthews]

Thank you for the link. But I a have a date field that I need highlighted based on the date being over due. I have a deployment_date and a trained_date, the trained_date needs to be with in 6mts of the deployment_date. So I need it to show up in red if it is over due.

 

[Alansidman]

dateadd("m",6,[trained_date])>[deployment_date]

I think if you use this as the criteria in your conditional formatting and set the format to Red, it will achieve what you need.

Alan

 

[SFCMatthews]

Ok I have taken (dateadd("m",6,[trained_date])>[deployment_date]) and added it to the expression under the conditional formating pop up tool. I dont know what i have done wrong but it is not working. I am a begener so I may have missed a step.

Thanks for your help.

 

[SFCMatthews]

I need help with this, I have dateA and dateB. I need to seee dateB light up when its outside a 6 mth window of dateA, dateB happens before dateA.
dateA dateB
1jan12 1june11
dateB is 7 mts from dateA which is outside the 6 mt window so it should be red.
Any thoughts on this?

 

[Alansidman]

Look at the attached. To see the conditional formatting, open the form in design view. Put your cursor on the textbox marked DateB and then right click on it. Click on conditional formatting and look at the set up.

Alan