I have an access database and i set the format with MS
Access and the DB Wiz to display the date as in
month/day/year. for some reason when someone creates a
new record from the website, the timestamp always records
the daye as day/month/year. why is this and how do i
keep it from doing it that way?

>-----Original Message-----
>I have an access database and i set the format with MS
>Access and the DB Wiz to display the date as in
>month/day/year. for some reason when someone creates a
>new record from the website, the timestamp always records
>the daye as day/month/year. why is this and how do i
>keep it from doing it that way?

Data formats you specify in Access have no effect on the
way the FrontPage Save Results component displays the data.

You can change the appearance of the confirmation page
FrontPage displays after adding a record. If you want to
pursue this browse:

Customizing Form Confirmation Pages
http://www.interlacken.com/winnt/tip...ow.aspx?tip=41

but I must warn you, there's still no control over date
formats.

if you absolutely *must* change the date format your
visitors see, you'll need to abandon the Save Results
component and write your own ASP page instead. This isn't
as difficult as you might suspect. For more info, browse:

Saving Form Data in a Database
http://www.interlacken.com/winnt/tip...ow.aspx?tip=44

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------