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 though...so 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.

Outcomes