andymarkbrown Posted October 13, 2003 Posted October 13, 2003 This is probably very basic, but please help as it's driving me mad. I have setup a database with a auot entry (creation) Date field. I have formatted the date field to day/month/year. I have also set my system (date/time) parameters (MAC OSX) to the same format. However, when I go to do a find in the Date field, I get the error message saying that I must enter the data as month/day/year. Is there any possible way to change the stored date parameters to day/month/year so that my search entry will be accepted? Thanks in advance.
-Queue- Posted October 13, 2003 Posted October 13, 2003 Try saving your file as a clone and importing your data back into it. The clone should maintain your current system settings instead of those from the computer on which it was created.
andymarkbrown Posted October 14, 2003 Author Posted October 14, 2003 Great stuff - it worked a treat. Many thanks.
Recommended Posts
This topic is 7711 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now