Hi,
I am not sure, what your exactly looking for.
i want to find max tenure of guests on the invited account
what is the calculation for tenure ??
is it " Userlastlogindate - usercreatedate" is the calculation. if yes then you can calculate tenure by using interval function
interval( Userlastlogindate - usercreatedate,'dd hh mm')
you can use the max function to find the max of tenure against each invited account.
I have attached the file which contains date field and i have accountid, userid over which i want to count.
which filed you want to count ? is it accountid and userid over the date field??
on which date field? usercreatedate or Userlastlogindate?
would request you to kindly provide the sample data along with expected output in order to help you solve this problem.
Thank,
Bhaskar
