VB & Database, Problem accessing record from SQL Data base Date/Time Field

Problem accessing record from SQL Data base Date/Time Field

Problem accessing record from SQL Data base Date/Time Field

Author	Message
Bruce Johnso #1 / 1	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 http://www.--.com/ ** Sent via Developersdex http://www.--.com/ ** Don't just participate in USENET...get rewarded for it!
Thu, 05 Aug 2004 15:31:09 GMT

Page 1 of 1

[ 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