Display total if in date range 1

[LouieGrandie]

Have a formula question. I need to write a formula that says if {AR_InvoiceHistoryHeader.InvoiceDate} is between 11/01/2013 and 10/31/2014 then {AR_InvoiceHistoryHeader.TaxableSalesAmt}+{AR_InvoiceHistoryHeader.NonTaxableSalesAmt} else 0 but not sure how to do that. There will be three formulas really, one for 2013 to 2014, one for 2012 to 2013 and one for 2011 to 2012.

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[kray4660]

One possible solution:
if {AR_InvoiceHistoryHeader.InvoiceDate} >= date("11/01/2013") and {AR_InvoiceHistoryHeader.InvoiceDate} <= cdate("10/31/2014") then {AR_InvoiceHistoryHeader.TaxableSalesAmt}+{AR_InvoiceHistoryHeader.NonTaxableSalesAmt} else 0

 

[LouieGrandie]

Hey thanks that worked. I had wondered if there was a "Between" function like in Access

Visit Sage's Online Community

http://community.sagemas.com/sagemas/?category.id=SageMAS90and200Disc

 

[kray4660]

In the Crystal Reports Select Expert. It basically translates the between option to {AR_InvoiceHistoryHeader.InvoiceDate} in cdate("11/01/2013") to cdate("10/31/2014"). I am sure there are other ways to do it.