Find Last Month Records

J

Jeffrey .w.

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
 
J

Jeff Boyce

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time format hh:nn drops leading zero 0
query Last month records 1
Date conversion 7
What are the proper Criteria for a Field? 3
Properties - Format, Input Mask, Validation Rule 5
Zero-fill existing data 4
Looking for criteria in query that filters based on last month'srecord date 11
Display missing records? 5

Top