Vanessa Posted May 15, 2002 Share Posted May 15, 2002 I have created date fields for users to input a date into [not necessarily current date]. However I don't seem to be able to find a way to enter the data in the usual English way - ie: we normally enter the day first, then the month. Although I can format the field to display the date as dd/mm/yy, most users will try and enter the data in this format and will then be faced with an error message. Can you help me please? Quote Link to comment Share on other sites More sharing options...
blackcat Posted May 15, 2002 Share Posted May 15, 2002 Vanessa What error messages are they getting. Steve Quote Link to comment Share on other sites More sharing options...
andygaunt Posted May 15, 2002 Share Posted May 15, 2002 Vanessa, In your format menu is the Use system formats in grey or in black. If it is in black, then that database is not set to use your system formats (eg British), but probably American. You can set the use system formats to on, or you can save a copy of your database as a clone (no records) and then import your data into this clone. By saving as a clone with no records it sets the database to the current system formats. HTH Quote Link to comment Share on other sites More sharing options...
Vanessa Posted May 15, 2002 Author Share Posted May 15, 2002 Thanks, Andy - it seems the sytem settings on the computer were not set correctly! Quote Link to comment Share on other sites More sharing options...
andygaunt Posted May 15, 2002 Share Posted May 15, 2002 Vanessa, Always happy to help. Glad that solved the problem. Quote Link to comment Share on other sites More sharing options...
Vanessa Posted May 15, 2002 Author Share Posted May 15, 2002 By the way - what does HTH mean? Quote Link to comment Share on other sites More sharing options...
Stuj Posted May 15, 2002 Share Posted May 15, 2002 probably Happy to Help Quote Link to comment Share on other sites More sharing options...
dj Posted May 15, 2002 Share Posted May 15, 2002 Originally posted by Stuj:[qb]probably Happy to Help[/qb] Hope This Helps HTH Dj Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.