Thread: VBA / SQL: problem with dates
View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
tony h[_2_] tony h[_2_] is offline
external usenet poster
  
Posts: 1
Default VBA / SQL: problem with dates

Another problem that can occur with dates results from the fact that
DATE field is actually a DATE&TIME field. Depending on how you forma
your output you might not see that a time is part of the value
Depending on how the date field gets populated you may get a time valu
as well. This will affect the selection as 1/1/5 10:15 is not the sam
as 1/1/5

Regard

--
tony
-----------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...fo&userid=2107
View this thread: http://www.excelforum.com/showthread.php?threadid=39214

Reply With QuoteReply With Quote