Need to write SQL statement to pull 1st of month

T

Tina

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

John Vinson

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]
 
Top