More Than 2 Condition (Date Comaprison) in Set Analysis expression
In this application i m having one date field that is -Recivedate , another one date field that is First Disb date.(I am using this one to make selection.....) now i want one more expression in union to that this expression ... Where if Recieve Date is greater than First disb date(or in other words -Month(RecivedDate )should be greater than Month (Selected) ---This field is coming from First DISB Date then all my fileno from aug2001 to till my selection.......
Can you suggest me sumthing ...... You can just gimme suggestison(in set analysis) rest i can apply .... According to me expression should be like this...
=COUNT( {1<YM={">=$(=MonthName(DATE('
28/08/2001')))<=$(=MAX(YM))"}, Rmonth={">MonthName'}>} DISTINCT FILENO) But this is not working ..... Any guesses
QVW(Doccument ) is attached for your understanding and refrence..........