Guys i am getting an err msg "D1 invallied identifier". I want to select data from a table where the date value is today such that i declared

Dim d1 As System.DateTime = System.DateTime.Today

and used d1 in my query as
select * from STTM_CUST_AC where DATE_MODIFIED = D1

any suggestions and corrections to the above code