Find Last Month Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to find records from the previous month? (e.g. Febuary). The date field has been created using an input mask, which is set to 00/00/0000. Is their any query that can do this? I have tried Month([Joing Date])-1 but this did not work. Help please
 
Jeffrey

An input mask simply constrains your data entry. A 'format' simply
constrains your display. What's the field data type of the underlying
data -- is it a Date/Time type field.

"Last" month is the current month minus 1. One approach to a selection
criterion might be to include a field in your query that 'calculates' the
month of your JoiningDate:

Expr1: Month([JoiningDate])

and then include a criterion of something like:

Month(Date())-1

NOTE! THIS WILL FIND ALL "FEBRUARY" DATES, including last year's, and the
previous years'

?Maybe you don't JUST want the month to be February?
 
Back
Top