Delete by number of months old

  • Thread starter Thread starter stumpy
  • Start date Start date
S

stumpy

using <DateAdd("m",-6,Date())
i can delete dates greater than 6 months old but is it possible to do using
an input so the month count can be varied.
Something along the lines of <[oldest date to Keep] but to have it as the
number of months being inputed instead of the date

Any help is appreciated
 
Much appreciated, Thanks.

RonaldoOneNil said:
<DateAdd("m",[How Many Months]*-1,Date())

stumpy said:
using <DateAdd("m",-6,Date())
i can delete dates greater than 6 months old but is it possible to do using
an input so the month count can be varied.
Something along the lines of <[oldest date to Keep] but to have it as the
number of months being inputed instead of the date

Any help is appreciated
Click to expand...
Click to expand...
 
Back
Top