paraphs just post ... calculate for deletion 6 month back

[sal21]

i need to delete all records based six month back based current month and year...

in this case all <01/09/2015

note:
field is named DATE1 (shorth date dd/mm/yyyy)
I use vb6 and access and ado

[HansV]

Why is "six months back" <01/09/2015?

[Mark L]

BTW, you said "field is named DATE1 (shorth date dd/mm/yyyy)". In case you may not understand Date fields, they are actually Date/Time fields. A "short date" is merely a format, it is not a data type.

Also, if you plan on entering a specific date (such as deleting all records where Date1 is before July 1, 2016), I think you need to use "...WHERE Date1<#07/01/2016#". I'm not 100% sure about this, but I think if you use the # to define a date, Access expects this to be in mm/dd/yy (or /yyyy) format, even though you may normally express this date as 01/07/2016. Instead, you might use something like "...WHERE Date1 < Date()-180".