need help to extract this week data from access table

[jagu143]

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

 

[NARAYANK991]

Hi Jayesh ,

Try this :

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

Narayan

 

[jagu143]

Hi Jayesh ,

Try this :

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

Narayan

thank you!

regards,
jagu