Problem accessing record from SQL Data base Date/Time Field 
Author Message
 Problem accessing record from SQL Data base Date/Time Field

Are you using the DateDiff function for you comparison?  For example:

WHERE DateDiff(d,DateField, '1/1/02') = 0

Bruce Johnson
TAG Consulting

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!

Thu, 05 Aug 2004 15:31:09 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Problem Using Time Part of a Date-Time field in SQL-Server

2. ADO with Access Date/Time field not storing the time, just the date

3. SQL Base date vs VB Base date

4. Insert date and time field into MS Access with SQL

5. Null date values in Date/Time fields in Access DB

6. bound masked field to date/time field in access not formatting right

7. Matching system date/time with field date/time

8. PROBLEM - Selecting records based on Date Range

9. How to get icertain record by using Date/Time field at .MDB file

10. Want to auto update date field based on adding check in another field

11. how to select record with Date field??? (SQL)

12. Populating Null value in SQL Date/Time field


Powered by phpBB® Forum Software