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

Question

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.

'''

 (IF(LENGTH(TOTEXT({POP.PODADD}))=9)
        THEN (DateSerial ((TONUMBER("20"+Mid 
    (Totext({POP.PODADD}),4,2))),
                        (TONUMBER(LEFT(TOTEXT({POP.PODADD}),1))),
                        (TONUMBER(MID(TOTEXT({POP.PODADD}),2,2)))))
        ELSE (DateSerial ((TONUMBER("20"+Mid 
    (Totext({POP.PODADD}),5,2))),
                        (TONUMBER(LEFT(TOTEXT({POP.PODADD}),2))),
                        (TONUMBER(MID(TOTEXT({POP.PODADD}),3,2))))))

'''

Answer 1

The Crystal Runtime doesn't always "follow" custom formatting defined in Crystal Designer. If you need a specific formatting, convert the date to formatted text using a formula such as:

ToText({POP.PODADD}, 'yyyyMMdd')

The 2nd argument gives you control over the desired formatting.