M
MuSuLPhReAk
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?
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?