Skip to Content

Dates how to display all months in last year

Hi

How can I show the last 12 months from the reporting date in the horizontal axis of a cross tab report. I need to know how to set up the months eg build a variable

Thanks Will

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 30, 2017 at 01:03 PM

    how much data in your report? 12 months

    for to extract month multiple ways.

    for extract month name=formatdate([date];"Mmm")

    for month number=formatdate([date];"MM")

    Add comment
    10|10000 characters needed characters exceeded