Another thing to be careful of is the use of TranDate. If you're trying to sync, then "createddate" or "lastmodifieddate" might be better alternatives.