• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help to extract this week data from access table

jagu143

New Member
hi,

need help to selcet this week data from access table bleow is the code i created which is not working. please hlep.


strSQL = "SELECT distinct(loan_Number) FROM audit where Date_s >= BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 7 DAY ) AND CURDATE( )"

regards,
jayesh
 
Hi Jayesh ,

Try this :

strSQL = "SELECT distinct(loan_Number) FROM audit where Date_s BETWEEN DATE_SUB(CURDATE(),INTERVAL 7 DAY) AND CURDATE()"

Narayan
 
Back
Top