DSXchange

Who cares, we are having fun.

Hi craig, thanks for you reply.

chulett wrote:Since we don't know for sure what you need, it either needs to look like this:

[code1]if (Fundname2 <> Fundname1 or Fundname1='') and DateGenericDateDiff(Date2, Date1) < 365 then 0 else TNAamount2-TNAamount1[/code]
or:

[code2]if Fundname2 <> Fundname1 or (Fundname1='' and DateGenericDateDiff(Date2, Date1) < 365) then 0 else TNAamount2-TNAamount1[/code]
One of the two should be what you had in mind.

my reuqirement is

the same fundname exists in source, normally for the same fundname the filing dates (number days differnce) is 6 months (180 days), but if the same fund name exists more than twice i need to calculte change in amount for fund name if the no of days is not lees than 365,

the expression what i have written(first code in ur suggetsion) in stage variable is not giving proper output.

the expression is chekcing for same fund name and but it is not checking dategenericdiffernce (date2,date1) <365 ,

is there any wrong date function.

if u need any clarifiction in understanding my problem, i will provide you.


thanks