Incorrect date in pass-thru query

  • Thread starter Thread starter Liz C
  • Start date Start date
L

Liz C

I have a pass-thru query that's pulling a date from a table. The actual date
in the source table is 4/2/2009 11:59PM, but it shows in my pass-thru query
as 4/3/2009 with no time. I don't need the time, but I do need it to show me
the correct date. Any idea why this is happening and how to fix it?

Thanks for any help you can offer!

Liz
 
Basically, you should resolve that problem with the syntax of the database
hosting the data. As example, MS SQL Server can store the time up to the
milli-second (well, at least, in that order of magnitude), which is not
possible for Jet, so some rounding could occur unless you remove those msec
(with a format, then transmitting a string rather than a date, or otherwise,
such as transmitting the year part, the month part and the day part, and
reconstituting the date, on Access side, with DateSerial). But again, the
strategy depends mostly on the database hosting the data.


Vanderghast, Access MVP
 
Back
Top