date conversion

[The Mad Jammer]

I imported a bunch of records into a FMP 5.0 file. The dates I imported were al 07/01/05. Of course, FMP 5.0 thinks the date is 07/01/1905! The dates are stored in repeating fields, which makes converting them even more difficult. Is there any easier way to get FMP to realize that the year should be 2005?

Thanks

the Mad Jammer

[PeterHW]

If all values are the same, why don't you do a "replace contents". Input the correct value in one field (or all repetitions of that field) and perform the replace contents based on current field value.

If the number of repetitions is not too large and all values are the same that should be the quickest solution.

If the date value is not the same for all records, you could also do a "replace contents with calculated result". Assuming your field is called Date, the calculation would be Date + 36525.

HTH,

Peter

[comment]

Just in case there are some dates in January or February 2000, the calculation should be Date ( Month ( field ) ; Day ( field ) ; Year ( field ) + 100 ).

[The Mad Jammer]

Thanks PeterHW and comment.

In the end I created a script that looped through all the records and simply replaced the year 1905 with 2005. There was only one date I was looking for, which was 07/01/1905, so comment's calculation was not necessary, although it is the correct solution for virtually any other problem like this. And since the date I was concerned about always showed up in the first occurrence of the repaeating field, I didn't need to loop through every occurrence either.

Thanks again,

The Mad Jammer