sum to current date selection

[mogaka1234]

i am trying to add expenditure to current selection using: =sum({<[A/C Type]={'Direct Staff Costs*'}, FinResultsDate={'>=$(=date('01/09/2016','MMM-YY')) <=$(=date(max(FinResultsDate),'MMM-YY'))'}>} [USD amount])

My year starts in september. Anyhelp?

[Kushal_Chawda]

Please mark the answer as correct

[sonysree88]

Yes it will work correctly when you have the dual format