|
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? |
|