title: Is there a better way to format this date field in Crystal Reports? Im having trouble with a scheduling program and getting the correct data
body: <p>I have a program that runs reports on a schedule. For some reason the data it pulls is not the same as what Crystal Reports pulls. I was told it has to do with the way that the PO Enter Date field is formatted. It pulls fine from Crystal Reports but the scheduler shows different data. Im not sure where to go from here.</p>
  <p>'''</p>
  <pre><code> (IF(LENGTH(TOTEXT({POP.PODADD}))=9)
          THEN (DateSerial ((TONUMBER(&quot;20&quot;+Mid 
      (Totext({POP.PODADD}),4,2))),
                          (TONUMBER(LEFT(TOTEXT({POP.PODADD}),1))),
                          (TONUMBER(MID(TOTEXT({POP.PODADD}),2,2)))))
          ELSE (DateSerial ((TONUMBER(&quot;20&quot;+Mid 
      (Totext({POP.PODADD}),5,2))),
                          (TONUMBER(LEFT(TOTEXT({POP.PODADD}),2))),
                          (TONUMBER(MID(TOTEXT({POP.PODADD}),3,2))))))
  </code></pre>
  <p>'''</p>