Date problem

S

skc

I am saving a <% = Date()%> field to my Access backend
database from a FP Form. Trouble is, everything was Ok
for August, but as soon as the 1st Sept came then the
format changed to mm/dd/yyyy.

How can I overcome this?

Thanks.

skc
 
J

Jim Buyens

Do you mean that you entered 1/9/2004 and got back
9/1/2004?

Is the correct date getting into the database, but
something is formatting it incorrectly for output? If so,
what's formatting the output?

Or is the correct date not getting into the database?

Do you know how the localization settings on the Web
server are configured? If they're set to US English, for
example, the default date format will definitely be
mm/dd/yy, even it the browser is set to a different locale.

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)
|/---------------------------------------------------
*----------------------------------------------------
 
Top