Query specific date between 2 date fields?

• lag void

  Newbie

  Points: 1

  More actions

  September 10, 2007 at 8:42 pm

  #180953

  This is probably really simple, but it's giving me a tough time.

  I have to date fields. StartDate and EndDate.

  How could I find records where the date is between those fields?

  The records I'm looking for could be = to the startdate, = to the enddate, or between both date fields.

  I appreciate any help!

• cantor

  Say Hey Kid

  Points: 667

  More actions

  September 10, 2007 at 9:34 pm

  #732659

  select [the columns] from [the table] where [the date] between StartDate and EndDate ?