Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Count({<N_YEAR={'2014'},Policy_Start_Date = {'>=01-01-2014'},Policy_Start_Date = {'<=30-06-2014'}>} DISTINCT(C_POLY_NUM))
Thanks for the response.
But it still doesn't work.
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.