last three months date query

[msmuzila]

what would the criteria be for a query where i want the filter the
SHIP_DATE field for the last three months

 

[John Vinson]

what would the criteria be for a query where i want the filter the
SHIP_DATE field for the last three months

BETWEEN DateAdd("m", -3, Date() AND Date()

will get the range from April 19 through June 19.

John W. Vinson[MVP]

 

[John Vinson]

what would the criteria be for a query where i want the filter the
SHIP_DATE field for the last three months

BETWEEN DateAdd("m", -3, Date() AND Date()

will get the range from April 19 through June 19.

John W. Vinson[MVP]