Forums

ASP

This topic is locked

ASP form to Access database Date Format

Posted 11 Feb 2013 11:36:52
1
has voted
11 Feb 2013 11:36:52 Jacqui Brimacombe posted:
I have a webpage with an input form,with information to input part of which is the Date(). The page is set to <%Session.LCID = 2057 %>
To test I have the input type as text and the date in going in correctly in UK format dd/mm/yyyy.
When the submit button is pressed all the data goes to the Access database correctly but for one thing the Date has changed to US format mm/dd/yyyy.
Can anyone help with this as i cannot find any information that works for me.

Replies

Replied 28 Feb 2013 16:33:44
28 Feb 2013 16:33:44 Rey Collazo replied:
Howdy.
Look at the format field property for the date field while in Access. Hit F1 for help and you'll be able to change the format to the UK format. Maybe that will fix it...

Rey

Reply to this topic