Globally Format Date

[Frolickin]

I have been reading about dates today and am confused.

I am pulling some info from a database through DRW. One of the fields is
formatted as a short date in Access. In Access, whenever that field is
called, it is read as 4/19/2004.

When I call this through DRW, on the .asp page the date is formatted as
19/4/2004. The today's date on the same page is read 4/19/2004.

I found http://www.frontpagehowto.com/displaydate.htm. That did not work,
even after I corrected the spelling of "format".

***ERROR***
Database Results Error
Description: No value given for one or more required parameters.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

One or more form fields were empty. You should provide default values for
all form fields that are used in the query.
***/ERROR***

Can someone point me to how to format the date field through DRW?

Very frustrated,
Fro.

 

[Skydolphin]

If you are using asp you could format the date in a variable in VBScript and then display that formatted date then it would display in the format that is being used by your computer's regional settings

DbDate = FormatDateTime(Date, 2)

then in your HTML display the date like this <%=DbDate%

Rhond