String ,Date, Conversion ,C# Sql server 2008 R2

Posted by Raja_89 under C# on 2/2/2015 | Points: 10 | Views : 501 | Status : [Member] | Replies : 2
Hai

I am using Sql 2008 R2 version
While viewing the date field in Crystal Report it shows field in string format instead of date format

How can i get a solution for this

Thanks
Regards




Responses

Posted by: ravidharmad-14450 on: 2/2/2015 [Member] Starter | Points: 25

Up
0
Down
After retrieving the data's from DB, You need to feed it in another data table with the type of datetime column. Then you should assign this record set to the report.



Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 2/3/2015 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi

Goto Field Explorer->Special Fields -> Date Date -> Right Click -> Format Object -> Select Date Tab change your Format.

Mark as Answer if its helpful to you

Raja_89, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response