none
formatdatetime function in ssrs 2008

    Question

  • Hello ,

    i usually use formatdatetime(sysdate,2) to only show date.

    But now i want to display someting like this..

    Qtr Ending Jan 2012

    how to i format the datetime to get Jan 2012

    Please advise.

    Thanks

    Madhavi

    Wednesday, May 02, 2012 2:56 PM

Answers

  • Hi,

    You can use

    =MonthName(Month(Today())) &" " & Year(Today())


    Please mark ANSWERED if my reply contributed to your solution.

    Wednesday, May 02, 2012 3:03 PM
  • Or, you could use:

    ="Qtr Ending " & Format(today(),"MMM yyyy")

    good luck


    Think out of the box

    Wednesday, May 02, 2012 3:08 PM

All replies

  • Hi,

    You can use

    =MonthName(Month(Today())) &" " & Year(Today())


    Please mark ANSWERED if my reply contributed to your solution.

    Wednesday, May 02, 2012 3:03 PM
  • Or, you could use:

    ="Qtr Ending " & Format(today(),"MMM yyyy")

    good luck


    Think out of the box

    Wednesday, May 02, 2012 3:08 PM
  • I like Format(today(),"MMM yyyy") that would be the right choice.

    Please mark ANSWERED if my reply contributed to your solution.

    Wednesday, May 02, 2012 3:17 PM