Conditional format for dates passed

  • Thread starter Thread starter Bob H
  • Start date Start date
B

Bob H

Recently from this group I recived help on the syntax to conditinally
format a cell/data if a given date was getting close to the present date.
Now I find that I need/want to do the same if a date has passed the
present date. Again I am not sure of the syntax, and what I have tried
doesn't work for me.

Thanks
 
Recently from this group I recived help on the syntax to conditinally
format a cell/data if a given date was getting close to the present date.
Now I find that I need/want to do the same if a date has passed the
present date. Again I am not sure of the syntax, and what I have tried
doesn't work for me.

Thanks
Click to expand...

Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information.
What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then
Date()
 
fredg said:
Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information.
What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then
Date()
Click to expand...

Ok, point taken.
So, what worked to conditionally format a date getting close was this:
Expression Is [Next Date test]-Date()<20

Then I tried for adate already passed:
Expression Is [Next Date Test]-Date()-10, and changed some values to
-5 or 0

I also tried the Field Value and Less than but couldn't get the date
value right as I though I had to use an actual value.

Thanks
 
I've been using the following for passed dates:

Expression Is: [fieldname]<Date()

James

Bob H said:
fredg said:
Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information. What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then Date()
Click to expand...

Ok, point taken.
So, what worked to conditionally format a date getting close was this:
Expression Is [Next Date test]-Date()<20

Then I tried for adate already passed:
Expression Is [Next Date Test]-Date()-10, and changed some values to -5
or 0

I also tried the Field Value and Less than but couldn't get the date value
right as I though I had to use an actual value.

Thanks
Click to expand...
 
Ok James thanks for that one, but what about if a date is missing, i.e a
date should normally be in the Last Date Test and Next Date test, but
suppose there is no date in either field? I want the user to know that a
date should be entered or the item should be tested pronto!
Thanks
I've been using the following for passed dates:

Expression Is: [fieldname]<Date()

James

Bob H said:
fredg said:
On Mon, 22 Sep 2008 16:34:05 +0000, Bob H wrote:

Recently from this group I recived help on the syntax to
conditinally format a cell/data if a given date was getting close to
the present date.
Now I find that I need/want to do the same if a date has passed the
present date. Again I am not sure of the syntax, and what I have
tried doesn't work for me.

Thanks

Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information. What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then Date()
Click to expand...

Ok, point taken.
So, what worked to conditionally format a date getting close was this:
Expression Is [Next Date test]-Date()<20

Then I tried for adate already passed:
Expression Is [Next Date Test]-Date()-10, and changed some values to
-5 or 0

I also tried the Field Value and Less than but couldn't get the date
value right as I though I had to use an actual value.

Thanks
Click to expand...
Click to expand...
 
Not sure here, but I would assume you would need to check for a Null value
for that field.

James

Bob H said:
Ok James thanks for that one, but what about if a date is missing, i.e a
date should normally be in the Last Date Test and Next Date test, but
suppose there is no date in either field? I want the user to know that a
date should be entered or the item should be tested pronto!
Thanks
I've been using the following for passed dates:

Expression Is: [fieldname]<Date()

James

Bob H said:
fredg wrote:
On Mon, 22 Sep 2008 16:34:05 +0000, Bob H wrote:

Recently from this group I recived help on the syntax to conditinally
format a cell/data if a given date was getting close to the present
date.
Now I find that I need/want to do the same if a date has passed the
present date. Again I am not sure of the syntax, and what I have tried
doesn't work for me.

Thanks

Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information. What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then Date()

Ok, point taken.
So, what worked to conditionally format a date getting close was this:
Expression Is [Next Date test]-Date()<20

Then I tried for adate already passed:
Expression Is [Next Date Test]-Date()-10, and changed some values
to -5 or 0

I also tried the Field Value and Less than but couldn't get the date
value right as I though I had to use an actual value.

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Ok James thanks for that one, but what about if a date is missing, i.e a
date should normally be in the Last Date Test and Next Date test, but
suppose there is no date in either field? I want the user to know that a
date should be entered or the item should be tested pronto!
Thanks
I've been using the following for passed dates:

Expression Is: [fieldname]<Date()

James

Bob H said:
fredg wrote:
On Mon, 22 Sep 2008 16:34:05 +0000, Bob H wrote:

Recently from this group I recived help on the syntax to
conditinally format a cell/data if a given date was getting close to
the present date.
Now I find that I need/want to do the same if a date has passed the
present date. Again I am not sure of the syntax, and what I have
tried doesn't work for me.

Thanks

Just a helpful tip to help you get good responses when asking
questions in newsgroups.
Words like 'That didn't work' gives any potential reader who might
want to help you absolutely no useful information. What didn't happen?
What did happen?
What did you expect to happen?
Exactly how did you implement the help given you?
Did you enter your table and field names in place of the generic ones
given?
Where did you place the code?
What is the exact code you wrote (copied directly from your database
and pasted here so we can see if you didn't simply mis-write the
code)?
Answers to those questions would be helpful to us .... to help you!

How are we to know whether what we suggest isn't what you have already
tried? :-(

Condition2
Field Value Is
Less then Date()

Ok, point taken.
So, what worked to conditionally format a date getting close was this:
Expression Is [Next Date test]-Date()<20

Then I tried for adate already passed:
Expression Is [Next Date Test]-Date()-10, and changed some values to
-5 or 0

I also tried the Field Value and Less than but couldn't get the date
value right as I though I had to use an actual value.

Thanks
Click to expand...
Click to expand...
Click to expand...

Just add another condition
Condition2 (or 3)
Expression Is
[YourDateField] Is Null
 
Back
Top