locked
Change Numbers to Date Formate RRS feed

  • Question

  • User1009570053 posted

    I am trying make a crystal report from our database, I am having issue with date & time filed, database shows the date and time in 2014/12/04 10:24:06 format but when I use the same filed in the Crystal Report it show 1,417,706,646 formate. is there any way I can change this number format to database format in Crystal reports.

    Thanks in Advance

    Wednesday, June 10, 2015 2:50 PM

All replies

  • User-1716253493 posted

    AFAIK, you can change the format of the field when designing report.

    Wednesday, June 10, 2015 8:40 PM
  • User1009570053 posted

    Date is store in database as an nvarchar, and Crystal report do not give me any option to change it to date.

    Thursday, June 11, 2015 8:11 AM