Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Thumbs up

    I have a form that contains 4 date field, all to be completed in order as events happen:

    [DateDue], [DateReturned], [DateVerified], and [DateClosed]

    DateDue is determined at the time the report is generated, so no problems there. However, I would like to use conditional formatting to change the background color to red if the date indicated has now "passed" (yesterday or before). Still no problems, I can get that done. However, I want it to stay red if the [DateReturned] information Is Null. Once the [DateReturned] field is completed, then I want the red background to return to white. Basically, the item is considered "overdue" (red background) until the field is completed, and then returns to the white background.

    I have tried using an "expression" in the Conditional Formatting dialog box, and as mentioned, can get the [DateDue] turned to red, but only bases on comparing the date entered to Date(), not to the [DateReturned] field being null.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try

    ([DateDue]<Date()) And ([DateReturned] Is Null)

  3. #3
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    Indiana, USA
    Posts
    141
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks Hans. That worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •