I'm fairly new to Filemaker and am having trouble exporting records to a .CSV file. Most of the exported data is correct, except for some of the dates. One of the records is the date 2007/04/06 and is changed to 2007/02/06. Two other dates appear to be swapped. The only thing all affected dates have in common is that they are the last record displayed in a portal. The two records that appear to have swapped dates are the first and last record displayed in the portal. Only the dates are affected - all of the other fields remain correct. Is there something I'm missing..? Something I should read with regards to exporting data from layouts with portals..?

Display of data in a portal has no relevance as to how the data exports from a table.

I have done a lot of exporting using csv, tab, sylk and have never had the problems you describe.

Could you provide a sample file for us to check so that perhaps we can understand in what way you are exporting the data and how you may or may not be exporting data from related tables?

If you can create a sample file with the relevant relationships and only a few select fields and you are still able to recreate the error - it will be very helpful for us to see this so we can have something to troubleshoot.

Thanks!

Thanks for your reply. I setup a clone and put in completely new records, and the error did not occur. I tried removing the records from the original that had the errors, but the error returned when I re-added them again. Anyway I just realized that the actual records have errors and it's because of the sloppy interface I've created. Its allowing me to change values that shouldn't be changed. Oops.

Cheers.