Member Avatar for Mhargail11

I love PRogramming

  • 2 Contributors
  • 2 Replies
  • 56 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Mhargail11

How to use Between Statement that can identify the month/date/year . thank you

Member Avatar for Reverend Jim

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#
Edited by Reverend Jim
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.