and (([Transactions.Txn Date] >= MinDateand[Transactions.Txn Date] <= MaxDate) or ([Transactions.Txn Date] >= MinDate2and[Transactions.Txn Date] <= MaxDate2))
, [Transactions.Line Items Txn Type])
//Variables: // Mindate set to 01/01/2017 // Maxdate set to 03/31/2017 // Mindate2 set to 01/01/2018 // Mindate2 set to 03/31/2018
The result is that I get al years and all transactions. It obviously does not like my "and/or" statement. All other conditions noted here have been tested and have the desired results. Can anyone help??
I did as you suggested with the same result, all sales transactions were included no matter the date. I’ve been doing ifs, ands, ors and butts for many years in a number of languages and the semantics look correct. I’m baffled.