access 2000 - select date dbquery

Results 1 to 2 of 2

Thread: access 2000 - select date dbquery

  1. #1
    Join Date
    Dec 1969

    Default access 2000 - select date dbquery

    hi ,i need select some data depended on date,but i can&#039t find a correct way so if you had some experience with this please help me :<BR><BR>This is what I used but nothing works<BR><BR>dotaz1="select * from sometable where DATUM="&date()<BR> &#039select fields which were created today<BR>dotaz2="select * from sometable where DATUM=date()"<BR> &#039the same<BR>dotaz3="select * from sometable where DATUM="&cdate(date())<BR> &#039the same<BR>dotaz4="select * from sometable where DATUM="&formatdatetime(date(),0)<BR><BR>but nothing works ... could you help me please....<BR><BR>I want to select a 7 days week old data too ...<BR>thankx :-)<BR>

  2. #2
    mackjack Guest

    Default RE: access 2000 - select date dbquery

    U got to use &#039#&#039<BR><BR>SELECT * FROM tblName WHERE fldDate &#062;= #" & someDate & "#" <BR><BR><BR>More at<BR><BR>

Posting Permissions

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