If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format Dates
How do I conditionally format dates that are more than one year old?
-- -Andy |
#2
|
|||
|
|||
Conditional Format Dates
On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote:
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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Conditional Format Dates
On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote:
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] |
#4
|
|||
|
|||
Conditional Format Dates
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." "Andy12" wrote in message ... How do I conditionally format dates that are more than one year old? -- -Andy |
#5
|
|||
|
|||
Conditional Format Dates
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! "fredg" wrote: On Thu, 17 Jan 2008 08:12:06 -0800, Andy12 wrote: 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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|