Expression with date

[upaliwije]

Dear Friends

I have following Expression which is working well.

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

but when I add the part in red   the following expression does not work

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {"$(=Max(TRAN_DATE))"},END_DATE = {"$(=Max(TRAN_DATE)-1, 'DD-MMM-YY')"}>} DISTINCT POLICY_NO)

Pls help me

[antoniotiman]

END_DATE = {"$(=Date(Max(TRAN_DATE)-1, 'DD-MMM-YY'))"}

[upaliwije]

Hi Antonio

Still the result is 0

[sunny_talwar]

END_DATE is in DD-MMM-YY format?

[upaliwije]

Yes Sunny

[sunny_talwar]

A single POLICY_NO can have single TRANS_DATE or multiple TRANS_DATE?

[upaliwije]

Basically a single TRAN_DATE but sometimes multiple dates can occur

[sunny_talwar]

In you screenshot above, do you have Date(Max(TRANS_DATE), 'DD-MMM-YYYY') = '15-Aug-2017'?

[upaliwije]

Yes Sunny

[Anil_Babu_Samineni]

Try to split and check where you are not getting. Like this?

Count({<RENEWED_PREMIUM = {'>0'}>} DISTINCT POLICY_NO)

Count({<RENEWED_PREMIUM = {'>0'}, RENEWED_DATE = {'$(=Max(TRAN_DATE))'}>} DISTINCT POLICY_NO)

......