R2D2 Posted October 21, 2004 Posted October 21, 2004 Hi ! Sorry, if this question has been here already... I converted a FM6 database to FM7. Now date-field doesn't work how they should. I want to enter dates in dd.mm.yyyy -format. In FM6 this was allraight, but in FM7 it returns 0.0.0000. If I enter dates in dd/mm/yyyy -format it works fine. What did I do wrong this time ? : Arttu
-Queue- Posted October 21, 2004 Posted October 21, 2004 Did you try making a clone of the file and setting the File Options to 'Always use current system setting'?
transpower Posted October 21, 2004 Posted October 21, 2004 Layout Mode | select date field | Format | Date | Format as | Numeric Separator: .
R2D2 Posted November 9, 2004 Author Posted November 9, 2004 Hi ! Ok. Now I have tried to use "System formats" and changed date separator to ".". Still it doesn't work. If I put there "Leave date formatted as entered" then it works. Any attempt to format the field results to "Monday 00.00.0000" which doesn't work. And more: I cannot enter a date in any other format than dd/mm/yyyy. In windows system formats the date format is set to dd.mm.yyyy . Any other suggestions ? Is this a bug in FM7 ? Arttu
transpower Posted November 9, 2004 Posted November 9, 2004 I again tested the "." separator and it works fine on my system (Windows XP, FM Dev. 7). Maybe you could send the forum an attachment of your table...
R2D2 Posted November 10, 2004 Author Posted November 10, 2004 Ok. Here it comes. With this test file (included) it still doesn't work. My Windows system settings the Date is in format "dd.mm.yyyy" (the format in use in Finland). DateTest.zip
transpower Posted November 10, 2004 Posted November 10, 2004 Wow--your problem is confirmed. It must be something to do with your version. I made sure to set English in the Edit | Preferences and use System (not File) settings when loading the file, and still the date would not format mm.dd.yyyy.
Lee Smith Posted November 11, 2004 Posted November 11, 2004 Hi Arttu, and Ronald, In versions before 7 (i.e. v6 and below), in order to change the date format from [color:"blue"]day, month, year to [color:"blue"]month, day, year (or vice versa), you have to save your file as a clone (i.e."Save a copy as", "Clone (no records)". Then create your records, and the file will change to your system settings. HTH Lee
MoonShadow Posted November 11, 2004 Posted November 11, 2004 Confirmed what Queue and Lee have told you. Save it as clone and it will work fine. No bug. No difference between versions. This is a known (well-documented and discussed) way to convert date formats. Transpower, Edit | Preferences and use System (not File) settings makes no difference. Correct. That is not the way to convert international dates. Again, no bug. That's just the way FM has always worked.
transpower Posted November 11, 2004 Posted November 11, 2004 Thanks, -Queue-, Lee, and MoonShadow for clarifying this for me. It simply wouldn't occur to me to have to clone the file, change the date format, and import the records back.
Newbies basicposter Posted December 5, 2004 Newbies Posted December 5, 2004 Hi there, I can not get this working under os x either, I have saved an empty copy of the file and done everything sugested, but the problem still presist. I want the date to be formated as dd.mm.yyyy but it fails to recognise anything but dd-mm-yyyy format (that is - instead of .). has this something to do with living in finland?
PCGMKTG Posted December 23, 2004 Posted December 23, 2004 I tried this for my problem (see my post - Help with creating a report-range of date fields in Layouts - http://www.fmforums.com/threads/showflat.php?Cat=&Number=113799) but it didn't work. Anyone esle able to?
Recommended Posts
This topic is 7373 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