how to create extract such that it should only give the record for which department has changed.

Summary:

how to create extract such that it should only give the record for which department has changed.

Content (required):

This is change only extract. I have created the extract for above requirement but i am getting the records for which department has not changed but their assignment has been changed for some reason.

Note: along with department i am using transfer date - which is assignment start date)

Here I need transfer date - as the date on which department has been changed. Does any one know how to get that.

Version (include the version you are using, if applicable):