-----Original Message-----
I have been having problems with date fields saved to a
db - the field is either put in by hand as dd/mm/yyyy or
from a date picker which completed the field for the
user via .....
All pages have <% Session.LCID=2057%> to show the UK
date format and the access db field is set to short date
Most dates save correctly but some are saving wrongly as
mm/dd/yyyy i.e. 07/10/2000 is showing as 10/07/2003 -
10th July 2003 rather than 7th October 2003.
Can anyone suggest a cure for this very irritating
problem>
Session.LCID controls how dates are formatted on output,
but not how they're interpreted on input.
Generally, the best solution is to use separate fields
for month, day, and year, and to make the month field a
drop-down list with 12 alphabetic choices.
Hardly anyone misinterprets a date like 7-Oct-2003.
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*