Date Formatting

[Mick]

I am attempting to output a date from an access database. It is stored on the
access database in the format dd/mm/yyyy in a field called [dateissue]. In
the asp I have custom changed to
SELECT * ,
format (dateissue,'ddd mmm dd yyyy') AS dateissue2
FROM clientbadge W HERE (ID = ::ID:

I would like dateissue2 displayed as "ddd mmm dd yyyy". The problem is, as I
am on a spanish server the date displays in Spanish as
"dom ene 09 2008" instead of "sun Jan 09 2008". I want it to display in
english please. You help would be appreciated, thank you.

 

[Kathleen Anderson]

Hi Mick:
Open the page in FrontPage and switch to Code View. Near the top of the page
there should be a statement that looks like this:

<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_LCID = 1033 %>

The value of FP_LCID is probably different in your page - try changing it to
1033 which is English.


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Mick]

Hi Kathleen, many thanks again for your interest, you have helped me so much
over the years, but sadly no change. The code was different so I did change
it as suggested, but same result. I have trimmed down this example page so if
you have the time you can see the dates and times, could you take a peek
please,

http://www.blue-badge.biz/_client2/editor/contract.asp?id=253

This is the code for the top of the page

<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-gb">
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_CharSet = "iso-8859-1"
FP_CodePage = 28591 %>

This is the custom query
SELECT *,
format (dateissue,'Ddd Mmm dd yyyy') AS dateissue2,
format (timeissue,'hh:mm') AS timeissue2
FROM clientbadge WHERE (ID = ::ID:

kind regards

Mick.

 

[Kathleen Anderson]

Well, it was a long shot. Can you try one other thing? Try changing

FP_CodePage = 28591

to

FP_CodePage = 1252

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Mick]

Hi Kathleen, thanks for your support. Sorry, same result.
kind regards
Mick