quote:No.The datetime format is liek this 7/15/2006 10:16:28 in db
but date() function returns this 7/15/2006
and therefore it does not return the correct value
You are not understanding.
By using the between keyword, which is inclusive, you will get all the "between" dates - which will be everything that has a date of the current date.
You cannont use "date_signed=" because your dates will (almost) never be equal to the "raw" date without the time portion tacked on.
What you need to do is either use the between, or the
sql = "select * FROM cmm_Users WHERE date_signed > '" & date() & "' AND date_signed < '" & (date()+1) & "';"
that mat41 supplied.
What we are suggesting is that you need to check for dates that are within a range, and that range must include all the valid datetime entries for the date you are checking.
Woody Z http://www.learntoprogramnow.com