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

Thanks
M

--

http://www.MettaWeb.com

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