Ole DB Select Count Statement
===

I have the following statement which I believe has missing brackets. Could someone correct my sql statement?

    var query = "SELECT COUNT(*) FROM usersTable WHERE Date BETWEEN Format$(DateAdd(“d”, 0, Now(), “mm/dd/yyyy”) AND Format$(Now(), “mm/dd/yyyy”)";

MS-ACCESS DB