Comparing Dates in Set Analysis Problem

Fri, 30 Nov 2012 10:54:55 GMT

Hi ,

i have a date field eligibility_date which has a date in 'DD-MM-YYYY' format my table structure is

i want to write an expression which will return me the count(itemcode) falling between a month lets say 'X' and count(itemcode) a on month 'X-1' ie .

current expression is

count({<ELIGIBILITY_DATE={">=monthstart(addmonths(ELIGIBILITY_DATE,-1))"}}>}itemcode)

its giving null values . my condition is that i want records for elibility_date and records for elibility_date-1 month .

i also tried count(if(date(ELIGIBILITY_DATE,'DD-MM-YYYY')<=MonthStart(AddMonths(ELIGIBILITY_DATE,-1)),itemcode,0))

but i required a set analysis based expression

Any Solutions ?

Thanks and regards ,

s_tushar.

Re: Comparing Dates in Set Analysis Problem

SunilChauhan — Fri, 30 Nov 2012 11:05:10 GMT

there is one extra curly brace

use below

count({<ELIGIBILITY_DATE={">=monthstart(addmonths(ELIGIBILITY_DATE,-1))"}>}itemcode)

hope this helps