Delete by number of months old

[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

 

[RonaldoOneNil]

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

 

[stumpy]

Much appreciated, Thanks.

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

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

 

[Allen Browne]

Try:
<DateAdd("m",-[How Many Months back],Date())