Text Box Expression

[#1]

Hello all,

I am trying to figure out a total sum of loss items with a certain date range. I would like to show that figure in a Text Box format. Currently, I need to reflect current month. But would also like the flexibility of saying Total Amount of Losses within for example 1/1/2016 and 1/15/2016.

I hope that makes sense.

Thank you,

Manny

[robert_mika]

Try

sum( {$<StartDate = {“>1/1/2016”}, EndDate = {“<1/15/2016.”} >} Sales )

[#3]

Thank you for the reply Robert. I am getting a "Error in set modifier ad hoc element list". I tried to enter instead of sales amount, what I am actually using. As, well as formatting the date format but it still is giving me that error.

Thanks again for your help on this.