Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2011
    Posts
    54

    Unanswered: Easy conditional formatting question

    I have a bunch of dates.

    I've made it so they are highlighted in red if the date has been passed.

    I used:

    field value is less than or equal to date()

    the fields show up red, but only those with a DAY before today, and with no consideration of the month and year (ie. todays the 19th, all days before that are red regardless of year and month)

    help?

  2. #2
    Join Date
    Jul 2011
    Posts
    54
    Nevermind, turns out the fields have to be date and not text

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by Chromatic View Post
    Nevermind, turns out the fields have to be date and not text
    store data in the correct datatype
    numbers in anyone of the numeric datatypes
    dates and or times as date/time

    the reason
    if you store them as text then when you try to sort or use specific fucntions you will have problems

    the classic symptoms are rows sorted as 1,10,11,12,2,20,21......,8,9
    or as you have proved not storing date time data correctly.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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