AND statement help

[Anonymous]

Hey I would like to something like, sum TransactionAmount thats between start and end dates, ( i would like to get the sum of transactions in a selected month )

if anyone could please point me in the right direction.

SUM( {< Year=, PeriodName=, postingDate={"<=$(vEndDate)" AND ">=$(vStartDate)"} >}  TransactionAmount)

thanks.

Bon.

[Anonymous]

I still haven't fixed this. I think all solutions provided is correct but currently im using the incorrectly data field. so I'll look further into which field is related.