Skip to Content

How to handle garbage values in crystal reports?

I have a field as FromDate in database which has a value 25-Dec-2016.
When I drag and drop the field in report, it shows me a garbage value as 1 Jan-4173.

How to handle this error? Can anyone suggest?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 18, 2016 at 08:35 AM

    Hi Sailee,

    Which version of CR is this and what is the database?

    Does the database show this field's type as 'Date'?

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 18, 2016 at 08:49 AM

    And which database are you reporting against?

    Please post the driver you're using as well.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded