Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
smalldatetime in Access
- Thread starter mrmc74
- Start date
SkipVought
Programmer
mrmc74,
Take one of your dates from your table and CONVERT it as such -- I suggest CDbl since you are ALSO using TIME
You'll see that you DATE is just a NUMBER -- actually, the NUMBER of days since 1/1/1900.
The "fractional" part is TIME in days.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Take one of your dates from your table and CONVERT it as such -- I suggest CDbl since you are ALSO using TIME
Code:
MsgBox CDbl([MyDate])The "fractional" part is TIME in days.
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question