Thank you for your post.
I just found a copy of FileMaker Pro 6 and installed it on my Mac running Mac OS X 10.5.6. I created a new database file and added a Date field. When I enter 2/12/09, it expands properly to 2/12/2009.
Can you tell me more about your system? Windows or Mac? Operating system and version?
Are these dates imported from another application or are you manually entering them?
Thanks for your response. The actual FileMaker database is running on a Mac with an operating system version 10.4. All of the HTML is done on a Mac as well. The web interface, however, is used on both Macs and PCs, which is where the issue is occurring. It is the web publishing portion of FileMaker that is not working right, I believe.
Yes, these file were imported from Excel. However, even when I go to enter a brand new record which has never been imported from Excel, the date still expands to 1909 and not 2009. The dates imported correctly from Excel (version 2002 if that matters) as they read 2009 in the database. It is just when you go to change or edit a record that the date shows up as 1909. Furthermore, if you enter the entire year (2009) it is fine and will show up correctly. But, when just 09 is entered, that's when 1909 appears.
Thank you for the additional information.
I'm not sure what is the cause, which I know doesn't help you.
Let's create a new database file. Name it "TEST" and create one date field "DATE". Go to Browse and in the first record enter "2/12/09". Does this expand to 2009 or 1909?
If this works properly, then open your original file, pull down the File menu and select "Save a Copy As..." In the next dialog box, at the bottom, change the file type to "Clone (no records)", and let the file name default to the name of your existing file followed by Clone. Click OK.
Open the Clone file, add a record, and enter the date "2/12/09". Does this expand to 2009 or 1909? If the former, then you can import the original records into this new file.
Please continue to keep me updated.
Thanks again for your help. I will give this a shot this weeked and let you know the outcome.