Post reply

Formating date from YYYYMMDD to MMM/YYYY

  • December 19, 2012 at 10:32 am

    #271834

    Hello,

    I'm new to SSRS.

    I have a field (datatype decimal) in my ssrs report(edition :2010).The date in the firld is displayed in YYYYMMDD format .I'm buildling a parameterised report .With TO and FROM FILTERS, which will hold dates in MMM/YYYY format.

    Any ideas on how to change the date format

    Thanks

    Swarup

  • December 19, 2012 at 11:43 am

    #1570245

    I mean I want to convert the date field from YYYYMMDD format to MMM/YYYY..

  • December 20, 2012 at 9:41 am

    #1570598

    I still don't understand your question.

    The date in the database is a Decimal, and stores dates in YYYYMMDD format?

    and you want to create a parameter TO and Parameter FROM that you can pass into the Dataset to pull correct records?

    or

    You have all the data set stuff figured out, and you just want to display the decimal value of YYYYMMDD from the dataset onto a tablix but show it in MMM/YYYY format?

  • January 2, 2013 at 11:25 am

    #1573005

    Try this expression:

    This example will show Jan/2013

    ="DATE PREPARED: " & format(Globals!ExecutionTime, "MMM/yyyy")

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

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