Skip to main content
Inspiring
May 25, 2006
Question

SQL date help

  • May 25, 2006
  • 1 reply
  • 174 views
Using Access...

I need to "select * from tablename where datefield >= date()"

This throws an error, can you help with syntax?


This topic has been closed for replies.

1 reply

Inspiring
May 25, 2006
http://office.microsoft.com/en-au/assistance/HA010546621033.aspx

Should help. I'll drop by in a moment when I have more time.

I'm assuming you're using ASP?

I'm not sure how the two formats correlate, but like i said will check back
in a few when i wake up more.