You are not logged in.
*note1: table1 field always having only one record.
*note2:table2 field having multifull records..
need to compare table1 currdate field with table2 nextreviewdate field.
if (currdate(field) > nextreviewdate)
no need to consider to count record
output need: if (currdate(field) < nextreviewdate)/( (if (currdate(field) > nextreviewdate)) + (if (currdate(field) < nextreviewdate) ))
can possible to create TOS job for the above things?
pls let me know any one....
can't you use a tmap with table1 as the input and set table2 as a (Lookup) inpur.
Than for the ouput, you set your condition such as date1 > date2 (in the tmap) then go to a tjavarow and add count... something around those lines.
If this is not helpful enough tell me and I'll send you some screenshots.
do you have a lot of 'date' in your second table ?
it will be perhaps a good solution to sort your second table in a first time and count until (while) lower or greater depending on sort is desc or asc
the best solution is jst find out the months difference between two table fields,if it is -ve jst add to count,if is +ve no need......
Thanking u for ur co-operation.......