CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 dd mm yy date format in list box

Print topic Send  topic

Author Message
Brian Gubb
Posted: 11/18/2003, 7:59 PM

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01C3AEBE.8B58D5A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Can anyone tell me how to display dd mm yyyy format in a list box? No =
matter what I try I always get mm dd yyyy. Using MSaccess and ASP

TIA
Brian Gubb

------=_NextPart_000_000A_01C3AEBE.8B58D5A0
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.2600.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Can anyone tell me how to display dd mm =
yyyy format=20
in a list box? No matter what I try I always get mm dd yyyy. Using =
MSaccess and=20
ASP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Brian Gubb</FONT></DIV></BODY></HTML>

------=_NextPart_000_000A_01C3AEBE.8B58D5A0--
Walter Kempees
Posted: 11/19/2003, 2:17 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0035_01C3AE8E.4A3E6CE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Just a quick response:
Check your date setting both in "Settings" for the project and in the DB =
connection settings.
ASP and MSAccess not my strong point, in PhP a format would do the =
trick.
Bye
"Brian Gubb" <b.gubb@amcom.co.nz> schreef in bericht =
news:bpeprg$usi$1@news.codecharge.com...
Can anyone tell me how to display dd mm yyyy format in a list box? No =
matter what I try I always get mm dd yyyy. Using MSaccess and ASP

TIA
Brian Gubb
------=_NextPart_000_0035_01C3AE8E.4A3E6CE0
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.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Just a quick response:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Check your date setting both in =
"Settings" for the=20
project and in the DB connection settings.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ASP and MSAccess not my strong point, =
in PhP a=20
format would do the trick.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bye</FONT></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@amcom.co.nz">b.gubb@amcom.co.nz</A>> schreef =
in bericht=20
<A=20
=
href=3D"news:bpeprg$usi$1@news.codecharge.com">news:bpeprg$usi$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone tell me how to display dd =
mm yyyy=20
format in a list box? No matter what I try I always get mm dd yyyy. =
Using=20
MSaccess and ASP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Brian =
Gubb</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0035_01C3AE8E.4A3E6CE0--
DonB
Posted: 11/19/2003, 5:26 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0083_01C3AE76.C53EB160
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

What Walter said will most likely work - CCS uses the default setting of =
the project if no other specification exists. =20

In the Listbox, you can specify the format of the "box" where selected =
value is displayed. You cannot specify the format of the "dropdown" =
area. However, you can opt to make the source a SQL statement that =
SELECTs data in the desired format. Alternatively, you can write a =
query to supply the dropdown with data and put the SQL in there instead =
of the Data Source property.

I believe that your Windows "Regional Options" will impact some of the =
standard format choices like "General Date". Check that in your Control =
Panel if all else fails.

--=20
DonB

http://www.gotodon.com/ccbth


"Walter Kempees" <kempe819@planet.nl> wrote in message =
news:bpffva$q3i$1@news.codecharge.com...
Just a quick response:
Check your date setting both in "Settings" for the project and in the =
DB connection settings.
ASP and MSAccess not my strong point, in PhP a format would do the =
trick.
Bye
"Brian Gubb" <b.gubb@amcom.co.nz> schreef in bericht =
news:bpeprg$usi$1@news.codecharge.com...
Can anyone tell me how to display dd mm yyyy format in a list box? =
No matter what I try I always get mm dd yyyy. Using MSaccess and ASP

TIA
Brian Gubb
------=_NextPart_000_0083_01C3AE76.C53EB160
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.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>What Walter said will most likely =
work - CCS=20
uses the default setting of the project if no other specification =
exists. =20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>In the Listbox, you can specify the =
format of the=20
"box" where selected value is displayed.  You cannot specify =
the=20
format of the "dropdown" area.  However, you can opt to make the =
source a=20
SQL statement  that SELECTs data in the desired format. =20
Alternatively, you can write a query to supply the dropdown with data =
and put=20
the SQL in there instead of the Data Source property.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I believe that your Windows "Regional =
Options" will=20
impact some of the standard format choices like "General Date".  =
Check that=20
in your Control Panel if all else fails.</FONT></DIV>
<DIV><BR>-- <BR>DonB</DIV>
<DIV> </DIV>
<DIV><A=20
href=3D"http://www.gotodon.com/ccbth">http://www.gotodon.com/ccbth</A></D=
IV>
<DIV> </DIV>
<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>"Walter Kempees" <<A=20
href=3D"mailto:kempe819@planet.nl">kempe819@planet.nl</A>> wrote in =
message=20
<A=20
=
href=3D"news:bpffva$q3i$1@news.codecharge.com">news:bpffva$q3i$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Just a quick response:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Check your date setting both in =
"Settings" for=20
the project and in the DB connection settings.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ASP and MSAccess not my strong point, =
in PhP a=20
format would do the trick.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Bye</FONT></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@amcom.co.nz">b.gubb@amcom.co.nz</A>> =
schreef in=20
bericht <A=20
=
href=3D"news:bpeprg$usi$1@news.codecharge.com">news:bpeprg$usi$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone tell me how to display =
dd mm yyyy=20
format in a list box? No matter what I try I always get mm dd yyyy. =
Using=20
MSaccess and ASP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Brian=20
Gubb</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0083_01C3AE76.C53EB160--
Tony Do
Posted: 11/20/2003, 3:50 AM

This is a multi-part message in MIME format.

------=_NextPart_000_00B1_01C3AFB9.30246D10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Check your Local Identifier th in Code Charge project setting, I would =
Select Australia (0c09) to have it display dd/mm/yyy
"Brian Gubb" <b.gubb@amcom.co.nz> wrote in message =
news:bpeprg$usi$1@news.codecharge.com...
Can anyone tell me how to display dd mm yyyy format in a list box? No =
matter what I try I always get mm dd yyyy. Using MSaccess and ASP

TIA
Brian Gubb
------=_NextPart_000_00B1_01C3AFB9.30246D10
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.2800.1276" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV><FONT face=3DArial size=3D2>Check your Local Identifier th in Code =
Charge=20
project setting, I would Select Australia (0c09)  to have it =
display=20
dd/mm/yyy</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@amcom.co.nz">b.gubb@amcom.co.nz</A>> wrote in =
message=20
<A=20
=
href=3D"news:bpeprg$usi$1@news.codecharge.com">news:bpeprg$usi$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Can anyone tell me how to display dd =
mm yyyy=20
format in a list box? No matter what I try I always get mm dd yyyy. =
Using=20
MSaccess and ASP</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Brian =
Gubb</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_00B1_01C3AFB9.30246D10--

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.