DATES

When using MS Access put a # before and after the date
Example: WHERE dateassigned=#7/7/2000#

When using SQL Server put a ' before and after the date
Example: WHERE dateassigned='7/7/2000'




Come learn HTML or Classic ASP in Honolulu, Hawaii!

HOME | SQL Tutorials | XML Tutorials | OKIWEB | EMAIL ME | ASP Alliance