Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

DB date format - Access problem LCID=2057

5 views

Skip to first unread message

Mettá

unread,

Sep 28, 2003, 10:35:11 AM9/28/03

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

Jim Buyens

unread,

Sep 28, 2003, 12:37:32 PM9/28/03

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
buy...@interlacken.com
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) ||
|/----------------------------------------------------\|
*------------------------------------------------------*

0 new messages