Date Formatting

  • Thread starter Thread starter Mick
  • Start date Start date
M

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.
 
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
 
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.
 
Back
Top