Sage 100

I have a customer who wants to add a date range in the standard statement printing. I know how to setup the parameter and selection but on the stock the invoice and transaction date are a formula. any suggestions on doing a selection on a formula using the in between date that the user enters. V2013.

Date range how? On invoices that print? if so you might try suppression logic.

The formula. I need to do a parameter on the formula on the STANDARD statement @InvoiceorTransactionDate. The field for the invoice date is a formula. I can't set a parameter to a formula.

I just added a date range and did the Report/Selection Formula/Group and it let me compare the formula to the paramteer.

So you added parameter for date and selected the formula field @invoiceortransactiondate.

Ditto what @BethBowers said. Group selection formulas aren't overridden by Sage like the Record selection formula is.

Can you email the rpt file?

yep.

gwirtjes@goism.com

I am unsure how you guys are creating a group or record selection on a SAGE formula. If I create a parameter called Begin Date - The formula is not available.

Report/Selection Formula/Group - NOT the wizard

Here you go...

I see exactly how you accomplished that. Thanks much @DanBurleson