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