Post reply

Format date within Tooltip

  • May 9, 2013 at 2:40 am

    #293127

    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

  • May 9, 2013 at 4:52 am

    #1613711

    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.


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • May 9, 2013 at 4:56 am

    #1613713

    Hi,

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

    Thanks,

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne

  • May 9, 2013 at 5:05 am

    #1613716

    Many Thanks

    regards

    P

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply