Brian Gubb
|
| Posted: 12/01/2002, 8:53 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C299C7.34730510
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a listbox populated by a field {gamedate} All the date options =
are set for dd/mm/yyyy.
If I select the date 13/10/2002 from the listbox the returned data in =
the grid is correct, same with 14/10/2002 so on...
But if I select the date 1/10/2002 through 12/10/2002 no data is =
displayed in the grid, because it thinks that the date format is =
mm/dd/yyyy.
I using Access 2000 and the {gamedate} field is date not text so that =
the list box sorts by date order, not text order.
Any ideas how I can fix this?
=20
Brian
------=_NextPart_000_0008_01C299C7.34730510
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2722.900" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>I have a listbox populated by a field {gamedate} All =
the date=20
options are set for dd/mm/yyyy.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If I select the date 13/10/2002 from the =
listbox the=20
returned data in the grid is correct, same with 14/10/2002 so =
on...</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>But if I select the date 1/10/2002 =
through 12/10/2002 no=20
data is displayed in the grid, because it thinks that the date format is =
mm/dd/yyyy.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I using Access 2000 and the {gamedate} field is date =
not text=20
so that the list box sorts by date order, not text order.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Any ideas how I can fix this?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C299C7.34730510--
|
|
|
 |
Stefano Cazzani
|
| Posted: 12/01/2002, 10:33 AM |
|
Messaggio in formato MIME composto da pił parti.
------=_NextPart_000_000A_01C29971.32F3FC40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
We had a similar problem using Access and CCS 1.07 using dates in =
European dd/mm/yyyy format.
To solve it, we had to set the Date Format in Connection setting (server =
tab) to Access format and mm/dd/yyyy date format even on machines =
configured with European OS date format as default.
Surprisingly, everything works fine this way: Date fields and labels in =
CCS are displayed correctyly in dd/mm/yyyy but now search works fine as =
well.
Give it a try, it's not very logical to me but it works!
Stefano
Milan, Italy=20
"Brian Gubb" <b.gubb@clear.net.nz> ha scritto nel messaggio =
news:asder2$psd$1@news.codecharge.com...
I have a listbox populated by a field {gamedate} All the date options =
are set for dd/mm/yyyy.
If I select the date 13/10/2002 from the listbox the returned data in =
the grid is correct, same with 14/10/2002 so on...
But if I select the date 1/10/2002 through 12/10/2002 no data is =
displayed in the grid, because it thinks that the date format is =
mm/dd/yyyy.
I using Access 2000 and the {gamedate} field is date not text so that =
the list box sorts by date order, not text order.
Any ideas how I can fix this?
Brian
------=_NextPart_000_000A_01C29971.32F3FC40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4731.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT size=3D2>
<P>We had a similar problem using Access and CCS 1.07 using dates in =
European=20
dd/mm/yyyy format.</P>
<P>To solve it, we had to set the Date Format in Connection setting =
(server tab)=20
to Access format and mm/dd/yyyy date format even on machines configured =
with=20
European OS date format as default.</P>
<P>Surprisingly, everything works fine this way: Date fields and labels =
in CCS=20
are displayed correctyly in dd/mm/yyyy but now search works fine as =
well.</P>
<P>Give it a try, it's not very logical to me but it works!</P>
<P>Stefano</P>
<P>Milan, Italy </P></FONT></DIV></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Brian Gubb" <<A=20
href=3D"mailto:b.gubb@clear.net.nz">b.gubb@clear.net.nz</A>> ha =
scritto nel=20
messaggio <A=20
=
href=3D"news:asder2$psd$1@news.codecharge.com">news:asder2$psd$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>I have a listbox populated by a field {gamedate} =
All the=20
date options are set for dd/mm/yyyy.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>If I select the date 13/10/2002 from the =
listbox the=20
returned data in the grid is correct, same with 14/10/2002 so=20
on...</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>But if I select the date 1/10/2002 =
through 12/10/2002=20
no data is displayed in the grid, because it thinks that the date =
format is=20
mm/dd/yyyy.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I using Access 2000 and the {gamedate} field is =
date not=20
text so that the list box sorts by date order, not text =
order.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Any ideas how I can fix this?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Brian</FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_000A_01C29971.32F3FC40--
|
|
|
|
|
