I'm working on a CR that has in 1 record 4 date fields.

now i need to create a formula (newthings) that does the following:

 

if 2 out of the 4 date fields have a date that is closer to currentdate then currentdate-14 the formule should get value1 else 0

 

i know i could do this in the record secelction also but i already have a lot of stuff in there. So i would like to make this check seperated so i can use a AND newthings = 0 to filter out all the rows where 2 dates are close to current dates.

 

hope this makes sence.

 

Adam

 

I made somthing simular now

 

shared numbervar tel;
tel := 0;
IF {ArtikelsLinked.TD} > currentdate - 14 THEN tel := tel + 1;
IF {ArtikelsLinked.COP} > currentdate - 14 THEN tel := tel + 1;
IF {ArtikelsLinked.IM} > currentdate - 14 THEN tel := tel + 1;
IF {ArtikelsLinked.BAS} > currentdate - 14 THEN tel := tel + 1;

 

but strange thing (or not so strange maybe) is that i can't get my tel field correct

what i mean is that if he will only count the COP field if the TD field already did a +1

so for example if both TD and COP are higher as currentdate -14 and IM and BAS are lower they will not be counted?

 

I'll adjust my formula with what you just wrote now and give feedback on that in a couple of min.

 

still curious what's wrong with my formula

 

Greetz and tnx

 

Adam

 

ps: what is the datediff(d, for ?

HTH

shared numbervar tel := 0;

IF NOT ISNULL({ArtikelsLinked.TD}) then
 IF {ArtikelsLinked.TD} < currentdate - 14 THEN tel := tel + 1;
IF NOT ISNULL({ArtikelsLinked.COP}) then
 IF {ArtikelsLinked.COP} < currentdate - 14 THEN tel := tel + 1;
IF NOT ISNULL({ArtikelsLinked.TDIMthen
 IF {ArtikelsLinked.IM} < currentdate - 14 THEN tel := tel + 1;
IF NOT ISNULL({ArtikelsLinked.BAS}) then
 IF {ArtikelsLinked.BAS} < currentdate - 14 THEN tel := tel + 1;

 

don't know why, it should continue, but sometimes Crystal is funny.  Give this a try, it should skip the 'bad' values