Date Time Format control 2

[LittleSmudge]

I have a table in which one column is populated from an Access 2k db via ASP with a Date/Time value.

It currently defaults to the confusing American mm/dd/yyyy hh:mm:ss AM layout despite my use of :-
lang="en-gb"
or
lang="en-UK"
or
DateTime="dd/mm/yyyy"
or
<!ENTITY % Datetime "dd/mm/yyyy" >
and other combinations in various places.

So how do I get the cell to display the date in the logical order ?


AND - I suppose, how do I get the database to accept dd/mm/yyyy format dates from the user during input and not get them confused either ?

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[ChrisHirst]

you need to set ASP to use UK regional settings

use session.LCID = 2057 in the affected (asp) pages.

more info in forum333 ASP

Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[LittleSmudge]

Thanks Chris.

I expected it to be an HTML issue.

So if I'm using a simple HTML page how would I then format the date ?

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[ChrisHunt]

HTML doesn't have any concept of "dates". You just give it a series of numbers and slashes and it displays them. Do a "View Source" on a finished page and you'll see what I mean.

It's ASP which is extracting the data from your database, converting it to (US) character format and spitting it out as HTML.

-- Chris Hunt
Webmaster & Tragedian
Extra Connections Ltd

 

[LittleSmudge]

Right - that help me understand a lot.

Thanks Chris. *



G.