Need to write SQL statement to pull 1st of month

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

Guest

How can I write a SQL statement to pull the 1st day of the month in a query
for all items ordered?
 
How can I write a SQL statement to pull the 1st day of the month in a query
for all items ordered?
Click to expand...

Could you explain what you mean by "pull"? And which month - the
current month?

Bear in mind - WE cannot see your database and do not know your
business.

As a criterion to retrieve all records from a table with the datefield
MyDate between the first of the current month and today's date, use a
criterion of

BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND Date()


John W. Vinson[MVP]
 
Back
Top