Well guys I've tried everything I can think of to get a date from access but it always says data mismatch. And in the database it shows a date like this: 9/11/00 Here's a list:

sql = "SELECT [Assigned] FROM [Password] WHERE [Assigned] = '091100'"
sql = "SELECT [Assigned] FROM [Password] WHERE [Assigned] = '09/11/00'"
sql = "SELECT [Assigned] FROM [Password] WHERE [Assigned] = '9/11/00'"


And every possible combination of those. Any ideas cause I got none now. Oh, I also tried #9/11/00# and #91100# which is the way Access lists it when I make a query.

hello,
  date is queried in access using #01/01/2004# not in quotes.

sql = "SELECT [Assigned] FROM [Password] WHERE [Assigned] = #09/11/2000#"

Thanks man, that worked. Appreciate it.

Actually, I do need to ask one more favor. How do you use the now/today function in that? I tried #Now()# but that didn't work. I got the page to load by doing sql = "SELECT [Assigned] FROM [Password] WHERE [Assigned] = Now()"

But I don't know will that be the date or just the text 'Now()'?

Hello,
When you compare for a date string(of any format that you use) you got to use # around it. When you compare that with a NOW(), you don't need # around it, as it is in-built function of ACCESS.

Correct usage - SELECT [Assigned] FROM [Password] WHERE [Assigned] = Now()

You can test all possiblities by executing them directly on your ACCESS db.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection