Date formatting on your dynamic pages?

[I Need Help!]

In Access I have date set to Date/Time with default value Date() and it is in the correct
format.

On website date appears as mm/dd/yy

I want it to appear as dd/mm/yy

[bthouin]

That's normal, that's the interesting US date format...

I made myself a neat little function that formats the date as dd.mm.yy
(Swiss format), and that works fine.


I Need Help! wrote:

> In Access I have date set to Date/Time with default value Date() and it is in the correct
> format.
>
> On website date appears as mm/dd/yy
>
> I want it to appear as dd/mm/yy
>
>
>

[I Need Help!]

..... and it is?




"bthouin" <bernard_thouin@bluewin.ch> wrote in message
news:d1hj47$kia$1@forums.macromedia.com...
That's normal, that's the interesting US date format...

I made myself a neat little function that formats the date as dd.mm.yy
(Swiss format), and that works fine.


I Need Help! wrote:

> In Access I have date set to Date/Time with default value Date() and it is in the

correct

> format.
>
> On website date appears as mm/dd/yy
>
> I want it to appear as dd/mm/yy
>
>
>

[Jon Spivey]

It would be
SELECT format(DateField, "d/m/yyyy")
FROM Table
You can format the date however you like, eg dddd=weekday name (Saturday)
ddd= short weekday(Sat) mmmm=month (March) mmm = short month (Mar) and so
on.

Cheers,
Jon

"I Need Help!" <iamedia-nospam@hotmail.com> wrote in message
news:d1i7up$ffm$1@forums.macromedia.com...

> .... and it is?
>
>
>
>
> "bthouin" <bernard_thouin@bluewin.ch> wrote in message
> news:d1hj47$kia$1@forums.macromedia.com...
> That's normal, that's the interesting US date format...
>
> I made myself a neat little function that formats the date as dd.mm.yy
> (Swiss format), and that works fine.
>
>
> I Need Help! wrote:

>> In Access I have date set to Date/Time with default value Date() and it
>> is in the

> correct

>> format.
>>
>> On website date appears as mm/dd/yy
>>
>> I want it to appear as dd/mm/yy
>>
>>
>>

>
>

[I Need Help!]

I was told this, and it works.


place this script <%Session.LCID = 2057%> just below the opening script (being UK) . See
link for the code that suites your own country.

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsmscLCID.asp[/url]





thanks for your the help!








"Jon Spivey" <jons@mvps.org> wrote in message news:d1ia03$hoa$1@forums.macromedia.com...
It would be
SELECT format(DateField, "d/m/yyyy")
FROM Table
You can format the date however you like, eg dddd=weekday name (Saturday)
ddd= short weekday(Sat) mmmm=month (March) mmm = short month (Mar) and so
on.

Cheers,
Jon

"I Need Help!" <iamedia-nospam@hotmail.com> wrote in message
news:d1i7up$ffm$1@forums.macromedia.com...

> .... and it is?
>
>
>
>
> "bthouin" <bernard_thouin@bluewin.ch> wrote in message
> news:d1hj47$kia$1@forums.macromedia.com...
> That's normal, that's the interesting US date format...
>
> I made myself a neat little function that formats the date as dd.mm.yy
> (Swiss format), and that works fine.
>
>
> I Need Help! wrote:

>> In Access I have date set to Date/Time with default value Date() and it
>> is in the

> correct

>> format.
>>
>> On website date appears as mm/dd/yy
>>
>> I want it to appear as dd/mm/yy
>>
>>
>>

>
>