frontpage msaccess dateformat problem

frontpage msaccess dateformat problem

Post by cmVuZWVuZX » Fri, 07 Jan 2005 02:05:08


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,
--
reneener
 
 
 

frontpage msaccess dateformat problem

Post by Thomas A. » Fri, 07 Jan 2005 02:19:33

Store the date in Access in a date field, then on your page where you want to display the date, you
have to set the LCID code for the Netherlands. The LCID code controls date and currency formatting.

See:
http://www.yqcomputer.com/

You would have to insert the code in HTML / Code View.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.yqcomputer.com/
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.yqcomputer.com/

 
 
 

frontpage msaccess dateformat problem

Post by cmVuZWVuZX » Fri, 07 Jan 2005 02:51:11

Hello Thomas,

Thanks for your reply!
Ive already did set the session.lcid to 1043 (Netherlands) but that did not
help. It goes rong for the first 12 days of every month.

Greetings,
Renee
 
 
 

frontpage msaccess dateformat problem

Post by Jon Spive » Fri, 07 Jan 2005 03:11:13

That won't help - the LCID sets the format but won't actually change around
the month and day. The safest way is to stick the date in ISO format -
yyyy-mm-dd, ie 2005-05-01. This way there's no room for ambiguity - this is
one of those issues you guys don't have to worry about :-)

--
Cheers,
Jon
Microsoft MVP
 
 
 

frontpage msaccess dateformat problem

Post by Jon Spive » Fri, 07 Jan 2005 03:15:01

Just to make clear I should have said 2005-01-05 for today's date

Jon