Mod Time Auto Enter Bug?

[BoatDriver]

I have a file I've been working on in FM8 that auto-enters the modification time for a record exactly 12 hours off the correct time. I've tried checking all the time formatting for the field in layout mode, double checked my system clock, etc., to no avail.

I've even created a garbage file to test the auto-enter function, and it gives the correct time in this file, but I still can't find the problem in the original file.

Any insight anyone has would be appreciated, as this is driving me nuts, not to mention wasting a huge amount of time!

[Søren Dyhr]

If you move into the afternoon will it be the day after won't it, but the dateformat will enter a time ahead of the event at the same day.

--sd

[BoatDriver]

After some testing, there's something really weird going on here...

I created 3 new fields...

Time - simple time field

ModTime - Timestamp field, auto-enter timestamp

TS - simple timestamp field

All field are placed on layout & set to leave dates & times displayed as entered. My system is set to use hh:mm:ss format in international system prefs. FM prefs are set to "Always use system formats".

When I type command-; in Time field and commit the record....

Time displays "16:34:20"

ModTime displays "2/6/2006 04:34:20"

When I type command-; in TS field...

TS displays "2/6/2006 16:34:20", but when I commit the record, it changes to "2/6/2006 04:34:20" and

ModTime displays "2/6/2006 04:34:26" !

Anybody got any idea what's going on here?? This is specific to a particular file...FM8 Adv. is not doing this in another test file.

[comment]

Does this file have a history, or did you create it under the current system? What happens if you clone the file?

[BoatDriver]

It's a new file I've been working on for about 2 weeks, with just a few junk records in it. I'll try cloning it and see if I can reproduce the problem. It was created under the current system, on the current machine.

The thing is, it's like FM is actually changing the data, not just the display format... 16:xx:xx is becoming 04:xx:xx.

Edited February 6, 2006 by Guest

[comment]

Sounds like the file may be corrupted (did it pehaps crash at some point?). I am not sure the data itself is being changed (16:xx:xx IS 04:xx:xx.in 12-hour display). You could check this by defining a calculation field (result is Number) = Hour (timefield), but I doubt it's worth it.

[BoatDriver]

Cloning the file worked...auto-entered times are now entered correctly.

Interestingly, in the corrupted file, all auto-entered times *were* being changed from PM to AM on committing the record...

Thanks very much for the idea of cloning the file, as I had convinced myself that I had some setting wrong that I just couldn't find.

[comment]

It would be probably safer to trash the file AND the clone and start anew.