DB date format - Access problem LCID=2057

  • Thread starter Thread starter Mettá
  • Start date Start date
M

Mettá

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
 
-----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>
Click to expand...

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