3
3ddy
I'm developing a database on a network which uses both
win98 and win2000 operating systems. My problem is with
the date and queries.
I develop most of my stuff on a win98 office 2000
computer. When I run my queries it works fine. I try it on
the win2000 with office xp on it and my queries that use
date() don't function as I expect
I did a simple return of date to see what actually was
returned
win98 I get 2/3/04 (mm/dd/yy)
win2000 I get 03/02/2004 (dd/mm/yyyy)
My problem is the queries use a format on a date field
which returns yy/mm. How can I get that query to work on
both systems?
win98 and win2000 operating systems. My problem is with
the date and queries.
I develop most of my stuff on a win98 office 2000
computer. When I run my queries it works fine. I try it on
the win2000 with office xp on it and my queries that use
date() don't function as I expect
I did a simple return of date to see what actually was
returned
win98 I get 2/3/04 (mm/dd/yy)
win2000 I get 03/02/2004 (dd/mm/yyyy)
My problem is the queries use a format on a date field
which returns yy/mm. How can I get that query to work on
both systems?