Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Format date within Tooltip Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 2:40 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:24 AM
Points: 157, Visits: 491
Hi

i have a tooltiip which is as follows:

="Current Age = " & DateDiff("yyyy",Fields!Dob_dte.Value,Now()) & " : DOB = " & Fields!Dob_dte.Value

EXAMPLE OF Fields!Dob_dte.Value = '1943-05-24 00:00:00.000'

When viewing the tooltip in the report the DOB part shows as MM/DD/YYYY format.

How can i get the Dob_dte.Value to show in the format of DD/MM/YYYY within the tooltip

Thanks in advance
Post #1450935
Posted Thursday, May 9, 2013 4:52 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:51 AM
Points: 702, Visits: 2,176
If you look at the properties of the report body there is a language property. Just change that to en-GB and that should do the trick. Let me know if that doesn't solve it.



MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1451017
Posted Thursday, May 9, 2013 4:56 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:51 AM
Points: 702, Visits: 2,176
Hi,

Here's a screenshot illustrating what i mean....

Thanks,


Simon




MCSA: SQL Server 2012
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne


  Post Attachments 
ReportLanguage.png (9 views, 17.64 KB)
Post #1451019
Posted Thursday, May 9, 2013 5:05 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:24 AM
Points: 157, Visits: 491
Many Thanks

regards

P

Post #1451023
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse