Work Relationship Start Date zero's

Summary

Report returning a value of 0-00-00 for Work Relationship Start Date

Content

Hi - We have a report where we are trying to capture all our transfers in a defined period, and the results are generating duplicate lines of data for some employee's, with the historical line (i.e. not the most recent data) has a Work Relationship Start Date of "0-00-00".  Copy of the xml attached.  My colleague suspects it is being caused by data that was imported into the system from a legacy system.

Thanks

Version

19A (11.13.19.01.0)

Code Snippet

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlVersion="201201160">
   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Employment Contract Real Time"" withinHierarchy="true">
      <saw:columns>
         <saw:column xsi:type="saw:regularColumn" columnID="c73e9ffdd3cd4305c">
            <saw:columnFormula>
               <sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula></saw:column>
         <saw:column xsi:type="saw:regularColumn" columnID="cdb4d6759c0970910">
            <saw:columnFormula>