export / import date format

[mem]

I am transferring some data fields from one FM DB to another FM DB.

but when the date field format of the source and receiving DB is

(for example) 14/3/05

Ihave no problem setting the destination date field

When the source date format is (say) 14 Mar 2005 the receiving end responds with a "invalid data supplied" error even if I set the layout date field formats to be identical.

I am running FM3 and FM4

Is there any way I can coerce the date field data en route and change the format ?

[-Queue-]

When you export from the first file, make sure that 'format according to current layout' is not selected. 14 Mar 2005 is not a valid date in FileMaker. You want it to be exported and imported as 14/3/2005. Then it can be formatted as desired.

[mem]

I am using an Applescript to grab data from one DB and wring it to a second DB.

my script basically does the following

go to window "testout"

set datecopy to field "date"

go to window "testin"

set field "date" to datecopy ----------- Error

I need to force the date format in datecopy to be equivalent to the "leave data formatted as entered" option.

[mem]

I have found a solution to this problem myself.

In the source DB I made a calculation field which is a copy of the original formatted date field but with result of the calculation as text rather than a date.

I am now able to move this new date field into any destination DB date field regardless of the date format of the destination.