FileMaker and Y2K

[Schlogg]

So FileMaker is Y2K compliant? Not quite.<br>
It appears that FMP have decided, in their wisdom, that dates in the year 2000 (and presmably after?) will be written with 4-digit years even when you specify 2-digit years. i.e 1 January appears as 1/1/2000.<br>
This is no big deal unless, like one of my clients, you have dozens of very tight report layouts.

 

[Schlogg]

Well, at least someone is replying!<br>
Looks as though I was a bit quick off the mark. FMP does default to a 4-digit year but won't insist on your keeping it.

 

[driven]

My issue with dates (not including my personal life) is that a date like 2/3/01 got written in the database as, get this, *1901*. You'd think they might have caught that one. Even appleworks deal with it better.

LS

 

[Schlogg]

LS
I have not had that problem. That would make FMP non-Y2K compliant. What version are you using?
I have had a similar problem with old databases converted up to V3/4/5. I just found all the apparently ancient dates and did a replace.
FMP's handling of dates is a bit odd. Out here in Oz, we use a logical date format - dd/mm/yy. For some strange reason, one of my customers has files which occasionally revert to mm/dd/yy format.
Regards,
Paul