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

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

Write New Post |

Search Forums | Answered

Resolved 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

0	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

0	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

Latest Posts