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.
 
Back
Top