querying dates

Results 1 to 2 of 2

Thread: querying dates

  1. #1
    Join Date
    Dec 1969

    Default querying dates

    hi! i need help in qurying dates in a an access db! i have a date field in my db which has a format month/day/year, suppose i only want to select those dates of a certain month, what should be my syntax. in querying whole dates, the syntax looks something like this : <BR>q = "select * from tblstats where [date]=#"&date&"#"; but what would be my syntax if a only want those on a certain month, for example march?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: querying dates

    select * from tblStats where [date] &#062;= #3/1/2003# and [date] &#060; #4/1/2003#

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts