Incorrect date in pass-thru query

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
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Reserved Error -7711 Pass Thru Query 5
Pass Parameter to stored procedure in pass thru query 7
Make Table Query based on Pass-Thru Query 1
Report Query 6
Using Bind Variables in pass-thru query to Oracle DB. 1
Doughnut Chart linked with the slicer in the pivot table 0
Formatting date gives bad results in query 2

Top