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

Posted by Raja_89 under C# on 2/2/2015 | Points: 10 | Views : 515 | 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 Raja_89, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts

Why abstract is required in C# (1)Updated
Can you provide the real time example for Deleage with event using in C# (1)Updated
Why thread required in C# (0)New
Millions of record show possible in Grid view (3)Updated
What is An electronic MVP Award certificate. (0)New
Return value from Startup.cs (0)New
Why do we need default column values in SQL Server? (1)Updated
Can we create Primary Key on more than one column? (1)
More ...