Sum field between two data

[Antonio1950]

Hi,

in a KPI chart I want show the total sales between two dates.

I have two fiels imported from sql server (BillDate and Sales) and two variables (v_startdate and v_enddate).

I use this expression:

=Sum({<BillDate= {">='$(=date(v_startdate))' <='$(=date(v_enddate))'"}>} Sales)

but the value showed is always 0.

Can someone help me?
Thank you

[Chanty4u · Accepted solution]

Try this 

Sum({<BillDate={">=$(=date(v_startdate,'YYYY-MM-DD')) <=$(=date(v_enddate,'YYYY-MM-DD'))"}>} Sales)

Please check your date formats and adjust accordingly 

[Antonio1950]

Thank you very much . The tip works perfectly