frontpageform msaccess wrong dateformat

[reneener]

Hello,

I do have a little big problem. Ive made a form in frontpage with a field
called "enddate" This is send to msaccess to the field "enddate" When i give
in 05-01-2005 it is written in msaccess as 01-05-2005 (I do live in the
Netherlands so i want European format) I've read some articles like the
article from 4guysfromrolla.com but i don't understand how to put it in the
form i created with fronpage. Its a common problem i understand. I
appreaciate your help .

Greetings,
Renee

 

[Jim Buyens]

Where do you see the "wrong" format appearing? In a Database Results Region?
In MS Access? Somewhere else?

Personally, I prefer the 5-Jan-2005 format so that no one has to decide
whether 01/05 means May 1 or January 5.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------

 

[reneener]

Hello Jim !

Well, what a coincidence, a few weeks ago i bought your book frontpage 2003
(dutch version) A realy helpfull book!
About my problem: everything goes fine but as i mentioned when the form
sends the date 05-01-2005 ( 5-jan-2005) to msacces, acces stores it as
1-5-2005 (1-may-2005) this happends for every first 12? days of every month.
Ive read some solutios but dont know how to implemend them.

Greetings,
Renee
(thanks for your reply!)

 

[Jim Buyens]

Responses interspersed...

Hello Jim !

Well, what a coincidence, a few weeks ago i bought your book frontpage 2003
(dutch version) A realy helpfull book!

No escaping me, eh? Seriously, thanks for buying the book.

About my problem: everything goes fine but as i mentioned when the form
sends the date 05-01-2005 ( 5-jan-2005) to msacces, acces stores it as
1-5-2005 (1-may-2005) this happends for every first 12? days of every month.
Ive read some solutios but dont know how to implemend them.

Greetings,
Renee
(thanks for your reply!)

Do I understand correctly, then, that you're viewing these dates in Access?

At first, I thought this might be an output problem, and that you might need
to format the date explicitly, as in Format(enddate, "dd-mm-yyyy")) rather
than just enddate. However, that doesn't explain the "first twelve days"
behavior.

If it's happening on input, you'll probably need to get your host to change
the settings under Control Panel, Regional And Language Options.
Unfortunately, this affects the whole server, and some other customers might
*like* the default being mm-dd-yyyy.

Otherwise, you may need to provide separate input fields for day, month, and
year, and assemble them yourself into the format the Access driver on the Web
server expects. You could do this in ASP.NET, ASP, or JavaScript.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| 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)
|/---------------------------------------------------
*----------------------------------------------------