Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Obtaining data within a date range in XL Reporter

Dear All,

I'm currently working on BS in XL reporter.

I was trying to extracting data in a date range, setting PER( Code >= @MthFrom Or Code <= @MthTo ) in report default tab.

However, the result is shown as all data as of current date. E.g. Selection criteria: >=200808, <=200809, the result is shown as from Begining to 200810.

Please kindly advise.

Thank you.



Edited by: Julie Wan on Oct 1, 2008 1:10 PM

Former Member
Former Member replied

Hello Julie,

Change the XL Reporter code to: PER( Code >= @MthFrom And Code <= @MthTo )

The "Or" was ending up making the Period selection open-ended on both ends of your range. Changing it to "And" will keep it contained between those two Period Codes.

Hope this helps,

Brent McDonell

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question