Fiedl Maturity Date - need to get fields from month only

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

Guest

Hi,

I have set up a database and need to do a query based on the Maturity Date
being March. This field is setup as Month date year.
 
Create your query and rather than include MaturityDate, enter the following
expression in a blank field of your query:
MDate:Month([MaturityDate])
Set the criteria for 3 to get March.
 

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

calculating maturity dates.. 6
Date field in a query 2
Maturity Date Calculation 1
Queries and Dates Issue 2
Previous Month Query 5
solution to table 6
exclude records 3
Query using two different date values 5

Back
Top