Post reply

How to use double quotation marks in an expression which has the FORMAT function?

  • November 21, 2012 at 5:42 am

    #271135

    I am trying to use the following expression:

    ="Parameter value selected is " & Format(Parameters!DateFrom.Value,"dd-MMM-yy")

    Obviously I cannot do this because the double quotation/speech marks required in the FORMAT function present a problem.

    I've tried "" and """ and even """" all to no avail.

    Question then as Google and forum search returns nothing specific: How to present double quotation/speech marks in an expression? Many thanks.

  • November 21, 2012 at 8:00 am

    #1561264

    I think this is what you mean by quote/speech marks... this works for me in SSRS textbox... either the """" or the chr function works for me...

    ="Parameter value selected is " & """" & format(Now, "dd-MMM-yy") & chr(34)

    The result I get is:

    Parameter value selected is "21-Nov-12"

    ---------------------------------------------------------------
    Mike Hahn - MCSomething someday:-)
    Right way to ask for help!!
    http://www.sqlservercentral.com/articles/Best+Practices/61537/
    I post so I can see my avatar :hehe:
    I want a personal webpage 😎
    I want to win the lotto 😀
    I want a gf like Tiffa :w00t: Oh wait I'm married!:-D

Viewing 2 posts - 1 through 2 (of 2 total)

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