Importing 2 weeks

[amigo]

Hi all,

Was wondering what the best way is to import the last 2 weeks of data from one filemaker file to another Filemaker file with a scripted button? Both files have the same layout.

Any help would be great

[John Mark Osborne]

Use a script with the Import Records script step. There is a restore option you can use to remember the import order of the fields. In other words, once you make the script, it will always import the same fields.

You'll also want to add a script in the source file that finds records from the last two weeks. That's because when you import FileMaker to FileMaker, only the found set will be imported. But, watch out! Make sure the source file is open or FileMaker will assume you want to import all the records.

Your find script might look like this if you want it to import based on the current date:

Enter Find Mode []

Set Field [MYTABLE::DateField; (Get(CurrentDate) - 14) & "..." & Get(CurrentDate)]

Perform Find []

You could also replace the Get(CurrentDate) function with a global date field and add a Show Custom Dialog with the global field as the input for the date you want to start with and go back 14 days.

[amigo]

Thanks John that works Great.