I love PRogramming
Mhargail11
0
Newbie Poster
Recommended Answers
Jump to PostFor MS SQL an example is
SELECT * FROM Orders WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-23'For AccessDB use
SELECT * FROM Orders WHERE OrderDate BETWEEN #1996-07-01# AND #1996-07-23#
All 2 Replies
Mhargail11
0
Newbie Poster
How to use Between Statement that can identify the month/date/year . thank you
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
For MS SQL an example is
SELECT * FROM Orders
WHERE OrderDate BETWEEN '1996-07-01' AND '1996-07-23'
For AccessDB use
SELECT * FROM Orders
WHERE OrderDate BETWEEN #1996-07-01# AND #1996-07-23#
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.