Obtaining data within a date range in XL Reporter

[Former Member]

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.

Regards,

Julie

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Dear Brent,

Thank you for your solution.

I've tried to change the formula to 'and' before, but misread the data and thought it was wrong. It works fine now.

Thank you!

Regards,

Julie