Re: Conditional format for dates passed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

JamesJ wrote:
I've been using the following for passed dates:

Expression Is: [fieldname]<Date()

James

"Bob H" <bob@xxxxxxxxxxxxx> wrote in message news:gb8n80$a6i$1@xxxxxxxxxxxxxxxxxxxx
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

.

Relevant Pages

  • Re: Lilys profession
    ... 15-month child. ... he's missing bits and pieces. ... James battled Voldemort for 5 minutes. ... memories which Snape safeguarded from Harry. ...
    (alt.fan.harry-potter)
  • Re: Date and time not showing on menu bar
    ... James) wrote: ... date and time, which should show on the top menu bar right hand side, is ... missing. ... I've checked the system preferences and they are set for the date and ...
    (uk.comp.sys.mac)
  • Re: Lilys profession
    ... he's missing bits and pieces. ... James battled Voldemort for 5 minutes. ... memories which Snape safeguarded from Harry. ... Would not Snape have retrieved his memories from the Pensive after ...
    (alt.fan.harry-potter)
  • Re: Lilys profession
    ... 15-month child. ... he's missing bits and pieces. ... James battled Voldemort for 5 minutes. ... memories which Snape safeguarded from Harry. ...
    (alt.fan.harry-potter)
  • Re: LDIFDE - Export
    ... Also noticed that a few little odds and ends were missing. ... > You will not really be able to maintain permissions when using ldifde. ... > HTH, ... >> Regards, James ...
    (microsoft.public.win2000.active_directory)