Saturday 15 May 2010

ms access - SQL Date Interval -


I have a table of MS Access that has a start date and an expiry date, how do I use a line from the table using SQL How to remove when the difference between two intervals to reach 6 months? I do not have to give date by me, I need this because I am asking ... any help plas? Use

to:

  from your_table where the date is in date (" 6 months and older for the record:  
  your_ table from where to remove DateDiff ("m", "m", start date, end date) = 6  

Start date, end date) & lt; = 6


No comments:

Post a Comment