For Miguel A. Baeyens

[#1]

You set your post so that we could not reply...

I use the following to calculate the sales between two dates.

Create 2 variables, vDate1 & vDate2. Set your dates to these variables.

=sum({$<Invoice_Date={">=$(#vDate1) <=$(#vDate2)"}>} sales_val)

[Miguel_Angel_Baeyens]

Thanks for your reply Carney.

The question was posted as "Question", so it must be possible to answer. Try again, anyway.

The thing is that one of the dates is in one Field (so I cannot load it in a variable, and that's why I try with (#=Date(Field))). As you can see in my example, I've tried that, I don't get any errors but it doesn't work.