Expression Between two dates

[upaliwije]

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {'>=15-Aug-2017'},RENEWED_DATE = {"<=$(Max(TRAN_DATE))"}>} DISTINCT POLICY_NO)

I want above expression to return data between these two dates RENEWED_DATE = {'>=15-Aug-2017'},RENEWED_DATE = {"<=$(Max(TRAN_DATE))" But it returns data even prior 15th Aug 2017   I may have made  mistake. Pls help me to correct it

[Kushal_Chawda]

below should work

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {">=$(=makedate(2017,8,15)) <= $(=Max(RENEWED_DATE))"}>} DISTINCT POLICY_NO)

or

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {">=$(=date(makedate(2017,8,15),'DD-MMM-YY')) <= $(=date(Max(RENEWED_DATE),'DD-MMM-YY'))"}>} DISTINCT POLICY_NO)

[sunny_talwar]

It might be better to use this as provided by kush141087

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {">=$(=Date(MakeDate(2017,8,15),'DD-MMM-YY')) <= $(=Date(Max(RENEWED_DATE),'DD-MMM-YY'))"}>} DISTINCT POLICY_NO)