Date Format

[Guest]

I think this is a date format issue.
Using Access 2000 and tables linked ODBC to SQL tables and all PC connected
thru LAN.

I get two dates based on the computer I run the report from!

1. First query has a column that calculates the date something is due based
on a bunch of values... This works fine.
2. Second query is made from query 1 so I can sort the data by min date.

3. First Report is made out of Query 1
4. Second Report is a sub report with just the date from query 2. I put
this subreport on the 1st report.

When I run the report from my PC the results are the nearest date for each
person.
But when I run it from any other PC it does not return the nearest date.

The only strange thing that jumps out, is that, dates that have a single
digit day (07/05/2007) will return a different day like 07/23/2007 and only
from all other PC's except mine...

Please help, I've been struggling with this....

 

[Guest]

Not surprising that no one answered this, it was kind of long.
I narrowed it way down, if anyone is interested, and reposted it under subj:
"Nearest Date" in Queries..

 

[John W. Vinson]

Not surprising that no one answered this, it was kind of long.
I narrowed it way down, if anyone is interested, and reposted it under subj:
"Nearest Date" in Queries..

It wasn't too long, Dan; it was too SHORT. It would have been a lot easier to
answer had you posted the SQL view of the queries.

Also your patience ran out in under two hours. Bear in mind that we're all
volunteers here - we get paid 100% of what you pay for the service, which is
to say nothing. Give us a bit of slack if you could, please!

John W. Vinson [MVP]

 

[Guest]

Looks like you have localization issues (American vs English formatting)
Try to format your dates in the independent format: dd-mmm-yyyy this always
has worked for me.