Set Analysis

[#1]

Hi Folks,

I am trying to get  count  of policy numbers between  two dates using the below expression. I am having issues in getting this to work. Please could some one guide me in the right direction.

Count({<N_YEAR={'2014'},Policy_Start_Date = {">=01-01-2014"},Policy_Start_Date = {"<=30-06-2014"}>} DISTINCT(C_POLY_NUM))

regards

Varghese

[sujeetsingh]

Try this

Count({<N_YEAR={'2014'},Policy_Start_Date = {'>=01-01-2014'},Policy_Start_Date = {'<=30-06-2014'}>} DISTINCT(C_POLY_NUM))

[#3]

Thanks for the response.

But it still doesn't work.

[MayilVahanan]

Hi

Try like this

Count({<N_YEAR={'2014'},Policy_Start_Date = {">=01-01-2014 <=30-06-2014"}>} DISTINCT C_POLY_NUM)

Hope your date format is DD-MM-YYYY.