Member Avatar for mailtosridar

help me how to select the record between two date...........................................

  • 4 Contributors
  • 3 Replies
  • 98 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by HI2Japan
Member Avatar for timothybard

Here's an example:

SELECT dateValue
FROM Table1
WHERE (((dateValue) Between #1/1/2008# And #1/1/2009#));
Member Avatar for HI2Japan

Or put this in the criteria of your query

Between [Enter Start Date] And [Enter End Date]

It will prompt for the dates.

If you want it to always be set dates, type

Between #M/D/YY# AND #M/D/YY# With whatever dates you want to set.

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.