ALL THE DATE DATA FIELDS ARE DEFAULTING TO 12/30/1899

[Ann28]

Hello Everyone –

CR version 9.2
DB2 UDB 8 on AIX

When I call the SP on the command line the dates are in the table.
On the CR it displays 12/30/1899 for all off my date fields.
When I browsed the data field it only shoes 12/30/1899.

Any ideas what the problem might be?

THANKS A LOT,
ANN

 

[lupins46]

Can't say what the specific issue is with DB2 but you have a zero date coming into CR. That gets converted into the date corresponding to zero which is what you are getting.

 

[Ann28]

Should I convert the date into something in my SP?
When I am pointing the table to the CR it works fine.
It's not picking up dates with the stored procedure

 

[lupins46]

If you don't want anything to appear in your report for this then you could use a conditional suppression formula on the date field.

 

[Ann28]

I converted all date fields into varchar & it worked