Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Application Programming


    

Blue Forest http://www.lslnet.com at 8:28 on August 25, 2006

Identify the data between two dates (sgl)

Mydate1 frame of the two texts, mydate2 imported dates
Then sgl phrase is :
Mysql= "select * from table where dt between #" &Cdate (mydate1) & "# and #" &Cdate (mydate2) & "#"
Or :
Mysql= "select * from table where dt" =# "&Cdate (mydate1) &" # and dt "=#" &Cdate (mydate2) & "#"

But not right. Dt less than mydate2 elected to the results of the data. Will it wrong, access+asp?

Some examples?




 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com