I use data compares a lot since it seems I have been involved in many upgrade projects lately. Two things I struggle with the most are number rounding and date formatting. In some cases this causes me to write sqls ahead of time to export data to new tables in order to compare. Ideally I would be able to write formulas directly in the compare. A couple of examples, one system does even number rounding so that a number such as 12.135 is presented as 12.13 and another system is presenting this same calculation as 12.14. I want to consider these a match if they are within 0.01 of each other. Another issue that happens to me a lot is when one system is presenting Timestamps and the other Dates. I would love to add a formula on one side or the other to convert the data element. I am currently using Toad Datapoint 22.214.171.1245
Thanks in advance for any tips you might be able to give me.