Forums

This topic is locked

Problems inserting dates

Posted 21 Jul 2001 09:56:34
1
has voted
21 Jul 2001 09:56:34 Jose Fuentes posted:
I'm developing a front-end application using ultradev4 in VBA asp model over an access database usin a string jet4 connection.

When i try to insert a date using the usual format in my country (Spain) dd/mm/aa the database gets the date as mm/dd/aa so the date is wrong registered. I can't find information about this issue in macromedia support web.

Can anybody give me any idea about how to control the format when inserting dates on an access database? <img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle> <img src=../images/dmxzone/forum/icon_smile_angry.gif border=0 align=middle>

Replies

Replied 21 Jul 2001 14:38:09
21 Jul 2001 14:38:09 Joel Martinez replied:
I did a little bit of research, and I think they may help:

support.microsoft.com/support/kb/articles/Q142/0/09.asp
support.microsoft.com/support/kb/articles/Q208/5/96.ASP

so based on those articles, I think you should check your regional settings in:
Control Panel&gt;Regional Settings

hope that helps,



Joel Martinez

----------
Is this thing on?....
Replied 21 Jul 2001 18:44:19
21 Jul 2001 18:44:19 Bjorn Fripon replied:
Hi,

Try using a "Specify Local ID" extension.
It will insert the appropriate aspcode
in your document

find it at the macromedia-exchange
or at members.prestige.net/ultradev/#

greetz and good luck

Jezter

Replied 22 Jul 2001 00:22:42
22 Jul 2001 00:22:42 Jose Fuentes replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I did a little bit of research, and I think they may help:

support.microsoft.com/support/kb/articles/Q142/0/09.asp
support.microsoft.com/support/kb/articles/Q208/5/96.ASP

so based on those articles, I think you should check your regional settings in:
Control Panel&gt;Regional Settings

hope that helps,



Joel Martinez

----------
Is this thing on?....
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Well, The regional options are allright, my microfot Acces is the Spanish Version. The only thing is that i'm usin mdac 2.6 and jet4 in english. Microsoft should answer again... Thanks for the help.

Reply to this topic