Post reply

Display previous month's last date on SSRS header

  • June 11, 2012 at 12:42 pm

    #262745

    HI guys..

    I am working on Report Builder 3.0 . I want to Display previous month's last date on report header so anyone can suggest me how i can set up that whenever report runs it shows every month's last date in report header like below.

    "Statics Data as of MAY 31, 2012" <--- MY report Header .

    which function should i use to display date as above format?

    thanks for kind help..

  • June 12, 2012 at 2:36 am

    #1499650

    logicinside22 (6/11/2012)

    HI guys..

    I am working on Report Builder 3.0 . I want to Display previous month's last date on report header so anyone can suggest me how i can set up that whenever report runs it shows every month's last date in report header like below.

    "Statics Data as of MAY 31, 2012" <--- MY report Header .

    which function should i use to display date as above format?

    thanks for kind help..

    =FormatDateTime(DateSerial(Year(Now()),Month(today()),0),DateFormat.LongDate)

    This will include the day name of the week: Thursday, May 31, 2012

    Use this to format the date as desired: =Format(DateSerial(Year(Now()),Month(today()),0),"dd-MMM-yyyy")

    gsc_dba

  • June 12, 2012 at 7:53 am

    #1499804

    Thanks It works for me ..

    Just making sure again it will display the date of every month's end right?

    really appreciated for your help and time

  • June 13, 2012 at 2:18 am

    #1500197

    Yes it will 🙂

    gsc_dba

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

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