May 5, 2010 at 5:48 am
Is this format for date expression correct? (i mean syntax)
I must get in dd-mm-yyyy format
CDate(Fields!Trn__Date.Value).ToString("dd-mm-yyyy")
May 5, 2010 at 5:56 am
I have Trn_Date like Jan-09-2010 09:13:00 AM
I have to represent this in dd/mm/yyyy format. what is the expression i must use?
May 5, 2010 at 10:08 am
Hi,
Try this, there can be other method also.
=Day(Fields!dt.Value)& "-" & Month(Fields!dt.Value)&"-"&Year(Fields!dt.Value)
Thanks & Regards,
MC
May 6, 2010 at 12:29 am
Hi Malvika,
As a better practice it is always suggested that one should always handle date-time manipulation at database level and not on SSRS interface.
Raunak J
May 6, 2010 at 12:42 am
Hi
Try this One
Format(Cdate(Fields!dt.Value),”dd-MM-yyyy”)
May 6, 2010 at 4:15 am
Hi All,
Thanks for your reply.
Now i have made the conv in my SP itself as Raunak has suggested.
But earlier i have used cdate many times without any prob, but this time i got error so asked.
Thanks for all your valuable suggestions.
May 6, 2010 at 4:38 am
Hi Malavika,
It seems your issue is resolved.
You must understand that Type conversions though seems easy add a lot of overload to underlying engine...considering that you have a large database to play with.
It is always desired to get the best, up to mark data on SSRS for publishing purposes.
By the way you practice or are you a professional.;-);-);-)
Raunak J
May 6, 2010 at 9:06 pm
Raunak Jhawar (5/6/2010)
Hi Malvika,As a better practice it is always suggested that one should always handle date-time manipulation at database level and not on SSRS interface.
Heh... not "always suggested" because I usually suggest that SSRS handle all formatting so SQL Server doesn't have to. In fact, it's usually suggested that no formatting be done by SQL Server and that whatever appliction you're using do the formatting. SSRS is just another application.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply