AnsweredAssumed Answered

delete all records over a certain age (or export)

Question asked by psychonaut on Jun 1, 2016
Latest reply on Jun 1, 2016 by Mike_Mitchell

hi i hope you are well.


i have a  customer with a file maker pro 11 database.


it has a 9gb datafile spanning 10 years of records.


i want to trim this down to the last, say, 2 years to make the whole thing easier to backup


i cant see how to do this. i have zero experience with filemaker so excuse me if this is a n00b question. i did about 2.5 yrs of sql 10 years ago ive some idea of how databases operate.


ive made a copy of the database for archive purposes, and now want to remove all the records except for the last 2 years from the live database. (or i can do it the other way round, or some other way if anybody has a better suggestion)


any idea as to how i can do this please? bear in mind i have NEVER seen filemaker before.