Displaying American Dates as English

[welshone]

Hello,
I am trying to convert american dates to English.
I am using MS Access ( the dates are ok here).
the intranet server has its locales set to american, but I cannot change this to UK.

when I use something liike this :

<%
datetime = Server.HTMLEncode(rs.Fields(&quot;StartDate&quot.Value)
y = DatePart(&quot;yyyy&quot;,datetime)
m = DatePart(&quot;m&quot;,datetime) : if m < 10 then m = &quot;0&quot; & m
d = DatePart(&quot;d&quot;,datetime) : if d < 10 then d = &quot;0&quot; & d
mydate = d & &quot;-&quot; & m & &quot;-&quot; & y
%>


it shows every date as 31-12-1899.

an anybody suggest something ?

cheers.
Jamie

 

[Guest_imported]

Welshone

Try dropping the HTMLEncode

Sadcow2

 

[welshone]

Hello,

that worked cheers SadCow2. ?/