Product: ImportOmatic
Description: This solution describes how to resolve the error: Date to cannot be before date from on an address record
Environment: All
Version: All


Because the Object is CConstitAddress, this error refers to the date fields on an address record.

This error can occur when updating an existing address that already has a date populated in the date to field. If a recent date is supplied for the date from field, The Raiser's Edge will give an error that the date to cannot be before date from.

ImportOmatic is not able to delete the previously populated date to field during import. There is a suggestion on our UserVoice site to add this functionality that you can vote on.

The current workaround is to open the address and manually delete the date on the address. You can do this either during the duplicate match screen by double clicking on the matching row and opening the address. Or you can do this in the advanced address processing screen. Double click on the matching address and remove the date to.

If this is historical data coming in and the date from is not necessary, that field can be set to Ignore and ImportOmatic won't try to add a more recent date in the date from field.
Please use the following link to locate the ImportOmatic User Guide for additional information.