Report Expression 2

[cosmoh2o]

Please help,

I have a value coming from a query in a report that is of the form "yearmonth" (the 4 character year is concantenated with the 2 character month - e.g. "200401" for January 2004) and I want to "parse" the value so that only the last two characters are displayed on the report (the month). Is there a simple way to do this inside ReportStudio with a report expression?

Thanks to anyone with any idea of how to do this.

 

[JGirl]

Using substring(datefield, 5, 2) should do the trick. This extracts 2 characters from datefield, starting at the 5th character (this is assuming that your date fields are all 6 characters)

J

 

[GJParker]

You could also use Right(datefield,2)

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[cosmoh2o]

Thanks to both JGirl and GJParker!! I will try both.