A
Andy12
How do I conditionally format dates that are more than one year old?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
fredg
How do I conditionally format dates that are more than one year old?
In form design view, select the date control.
Click on Format + Conditional Formatting.
Set Condition1 to
Expression Is
In the next dialog box, write:
[ControlName]< DateAdd("yyyy",-1,Date())
Change [ControlName] to whatever the actual name of your control is.
J
John W. Vinson
How do I conditionally format dates that are more than one year old?
Use a crieterion in the conditional format dialog of:
< DateAdd("yyyy", -1, Date())
John W. Vinson [MVP]
A
Al Campagna
Andy,
FieldValue Less Than DateAdd("yyyy",-1,Date())
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
FieldValue Less Than DateAdd("yyyy",-1,Date())
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
O
oldblindpew
NOTE: Do not change [ControlName] to the actual name of your control, rather,
change ControlName to the actual name of your control. In other words, do
not drop the brackets!
change ControlName to the actual name of your control. In other words, do
not drop the brackets!
fredg said:How do I conditionally format dates that are more than one year old?
In form design view, select the date control.
Click on Format + Conditional Formatting.
Set Condition1 to
Expression Is
In the next dialog box, write:
[ControlName]< DateAdd("yyyy",-1,Date())
Change [ControlName] to whatever the actual name of your control is.