date format - database results wizard

  • Thread starter Thread starter Andrew Murray
  • Start date Start date
A

Andrew Murray

Using FP 2003, & the database results components with an Access 2003
Database.

The web page is www.cursillo.perth.anglican.org, the problem is the top
right column headed "Calendar of Events", you'll see the date format is
mm/dd/yyyy rather than dd/mm/yyyy.

I have set a 'custom' date format in Access of dd/mm/yyyy and the field data
type is Date/Time and the field input mask is 99/99/0000;0;_ (which
"translates" to a date format like 29/12/2000 in Access itself, but not in
the results on the web page).

However, in the web site, the date is still showing a date like 9/29/2000
(mm/dd/yyyy - the US format) I'd like the UK format if possible to be
displayed on the page.

I'm not sure this is a Frontpage problem or an Access problem....It seems
all is correct in Access, but there's no way to change the format in
Frontpage. I've republished the database and the pages displaying the data,
and refreshing the page does not change the content (the dates) to the
format I'm after.

Apologies for cross posting but the issue seems to relevant to both
Frontpage & Access.

Thankyou.

Andrew
 
Andrew Murray said:
Using FP 2003, & the database results components with an Access 2003
Database.

The web page is www.cursillo.perth.anglican.org, the problem is the
top right column headed "Calendar of Events", you'll see the date
format is mm/dd/yyyy rather than dd/mm/yyyy.

I have set a 'custom' date format in Access of dd/mm/yyyy and the
field data type is Date/Time and the field input mask is
99/99/0000;0;_ (which "translates" to a date format like 29/12/2000
in Access itself, but not in the results on the web page).

However, in the web site, the date is still showing a date like
9/29/2000 (mm/dd/yyyy - the US format) I'd like the UK format if
possible to be displayed on the page.

I'm not sure this is a Frontpage problem or an Access problem....It
seems all is correct in Access, but there's no way to change the
format in Frontpage. I've republished the database and the pages
displaying the data, and refreshing the page does not change the
content (the dates) to the format I'm after.

Apologies for cross posting but the issue seems to relevant to both
Frontpage & Access.

Thankyou.

Andrew
Click to expand...

I expect the problem is in the code generated by FrontPage to format the
event date, after it has been extracted from the database, to build the
HTML for the rendered page. The date is stored in your Access database
in a date/time field, which has no inherent format. When working with
the dates in Access, the "dd/mm/yyyy" format you see is the result of
the Format and Input Mask properties you have applied to the field. In
reality, the date is stored internally in a floating point field that is
interpreted in a special way; all formatting is to look like a date is
applied as a rendering process, whether by Access or by the code that
puts it on the web page.

Unfortunately, I don't know enough about FrontPage to suggest a good way
to change the format it's using. I hope it doesn't come down to
changing the regional date settings on the web server.
 
Dirk Goldgar said:
Unfortunately, I don't know enough about FrontPage to suggest a good
way to change the format it's using. I hope it doesn't come down to
changing the regional date settings on the web server.
Click to expand...

You could conceivably convert the date into a properly formatted string
in the query that returns it; something like this:

SELECT
EventName,
Format(EventDate, "d/m/yyyy") As FmtDate
FROM
Events
WHERE
EventDate >= Date()
ORDER BY
EventDate;

Failing that, I have a feeling you'll have to get into the JavaScript or
VBScript generated by FrontPage to force the desired formatting, but as
I said before, I don't know anything about FP.
 
Back
Top