Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
<body> =COUNT( {1<YM={">=$(=MonthName(DATE('28/08/2001')))<=$(=MAX(YM))"},'$(Datediff)'=">(='90')">} DISTINCT AID)</body>
... and what are you trying to accomplish?
Hi Goran,
I NEED TO CALCULATE APPLID SINCE THEIR VERY FIRST DATE THAT IS (28 AUG 2001) TO TILL MY SELECTED MONTH ,ALSO IF THEIR DATE DIFFERECE (FIRST DISB DATE-SLECTED DATE) >90 THEN COUNT APPLID .
SO THERE ARE TWO CONDITION :
1. COUNT ALL FILES FROM 2001-AUG TO TILL MY SELECTED DATE.
2. THEIR DIFFERECE(FIRST DISB DATE-SELECTED DATE) SHOULD BE GREATER THAN 90 ,
THEN COUNT ALL APPLID AND GIMME RESULT......
Now any suggestion as everything is clear in front of You.......
suggest me that expression of greater than(datediff >90 --- how to write it)in set analysis....
Waiting for your reply...
Regards,
Dushyant