Buy Questpond's video subscriptions on huge discount.
DotNetFunda.com
Online: 742
Home > Forums > C# >

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

Posted by Raja_89 under C# on 2/2/2015 | Points: 10 | Views : 1148 | Status : [Member] | Replies : 2
Write New Post | Search Forums | AnsweredResolved Posts | Un Answered Posts | Forums Home 
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



Reply | Reply with Attachment
Alert Moderator 

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

Kumaraspcode2009@gmail.com

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

Login to post response

Latest Posts