Display format of Dates

[Phillip Jones]

I am told that in the UK the dates I display from my Access database using ASP-db Pro are in American format, and do not default to the machine local setting. Is there away around this?

many thanks

Phillip Jones

[John]

Hi Phillip,

You can use FULL VB formatting in dbMagicCell. Look at the following code:

<%
Response.write(&#34;<center><h3> Test Magic Cell - Date<BR></h3></center>&#34
Set X=Server.CreateObject(&#34;AspDB.Pro&#34
X.dbQuickProps=&#34;13;NWIND;orders;grid;4,auto,li ghtgreen&#34;
X.dbMagicCell=&#34;ShippedDate,,Format=[MM/DD/YY hh:mm:ss]&#34;
X.ASPdbPro
%>

Replace the format string inside the [...] to the one that fits your need.

Hope this helps,
John


On 2/25/99 5:54:06 AM, Phillip Jones wrote:
> I am told that in the UK the dates I display from my Access database using
> ASP-db Pro are in American format, and do not default to the machine local
> setting. Is there away around this?

many thanks

Phillip Jones

[Phillip Jones]

On 2/25/99 12:56:04 PM, John wrote:
> Hi Phillip,

You can use FULL VB formatting in dbMagicCell. Look at the
> following code:

<%
Response.write(&#34;<center><h3> Test Magic Cell -
> Date<BR></h3></center>&#34
Set
> X=Server.CreateObject(&#34;AspDB.Pro&#34

> X.dbQuickProps=&#34;13;NWIND;orders;grid;4,auto,li ghtgreen&#34;

> X.dbMagicCell=&#34;ShippedDate,,Format=[MM/DD/YY hh:mm:ss]&#34;

> X.ASPdbPro
%>

Replace the format string inside the [...] to the one
> that fits your need.

Hope this helps,
John


On 2/25/99 5:54:06 AM,
> Phillip Jones wrote:
> I am told that in the UK the dates I display from
> my Access database using
> ASP-db Pro are in American format, and do not
> default to the machine local
> setting. Is there away around
> this?

many thanks

Phillip Jones