Post reply

Formating date from YYYYMMDD to MMM/YYYY

  • 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 3 posts - 1 through 4 (of 4 total)

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