none
checking the Date between 2 dates in MS Access RRS feed

  • Question

  • Hi,

    Can you Please let me know the solution/query how to get the records between 2 dates in MS Access
    Let me explain detail.

    i m using the below query to get the records between 2 dates

    select distinct * from Tour_Other_details where empid = 1021 and d1 between from_date and  to_date  order by from_date

    d1,from_date,to_date i m passing the dates.

    eg : select distinct * from Tour_Other_details where empid = 1021 and #20-mar-09# between #16-mar-09# and  #31-mar-09#  order by from_date

    this is the table : tour_other_details

    Empid |  Ename |  From_date  | To_date  | Type_of_Issue |  No_of_days |
    -------------------------------------------------------------------------------------------
    1021      aaa        04-Mar-09    04-Mar-09    others                 1
    1021      aaa        12-mar-09     12-mar-09     others                 1
    1021      aaa        20-mar-09     20-mar-09     others                 1


     

    • Moved by sudarshans1Moderator Wednesday, March 3, 2010 3:31 AM Moving from TechNet Online: Future Plans Forum, please move or answer as necessary (From:TechNet Online: Future Plans)
    Monday, April 20, 2009 1:50 PM