Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2011
    Posts
    30

    Unanswered: Date Range Where Clause

    I have a combobox that shows dates for upcoming events. I would like to use a where clause so that no dates older than a month from now will be displayed. Can anyone offer a link or suggestion on how I need to formulate this statement. I have been doing research and have found nothing to fit my situation. thanks

  2. #2
    Join Date
    Nov 2010
    Posts
    84
    WHERE (((Table.DateOfEvent)>Date()-30));

  3. #3
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    I think you mean
    WHERE (((Table.DateOfEvent)>(Date()+30)))
    Sam

  4. #4
    Join Date
    Apr 2011
    Posts
    30
    Thanks it works like a charm. I knew it would be simple... just wasn't so sure about myself on this one. BTW the following is the one that did it for me. Thank you both.

    WHERE (((Table.DateOfEvent)>Date()-30));

Tags for this Thread

Posting Permissions

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