Import problem involving date & calculation fields

[SteveS]

I exported all of my records into a backup file. When I import the records back into the original file, two fields do not import correctly. The fields in question are 1) "Registration date" (date field) and 2) "Total Days" (calculation field)='s Status(CurrentDate)-registration date with storage options selected as unstored calculation.

My problem comes when the records are imported, the "Total Days" (calculation field is blank. I am currently using FileMaker Pro 4.

I would greatly appreciate any help that you could give me.

Steve

[QuinTech]

Hi, Steve. You will never be able to import data into a calc field, so forget that. Make sure that field is unstored, so that recalculation occurs whenever Status ( CurrentDate ) or Registration Date changes.

As for Registration date, what does the data look like when it is re-imported?

Jerry

[SteveS]

Jerry,

Thank You for your help, sorry it took so long for this response. The date field looks like this; (Sept 15, 2004), onstead of 9/15/04.

[-Queue-]

In your export dialog, did you specify to 'format output using current layout'? If you did and are on a layout where the date is formatted as MonthName Day, Year, when you export, then this would be expected behavior. You don't want it to format at all, so that it imports exactly as it was exported.

[SteveS]

Thank you!

That was the problem, I made the script after I exported the data in another layout using a different date format.