Hi All, Thanks for your valuable suggestions, Hi Michelle, Present don't have permission to access data query builder, i have permission to access only Reports, is there any way to this in reports (Version 6.4). Every Month i am creating manually new date variable 'Month end' (31st Jan 2015), and then i will convert the two date variables'MAX DATE' (20th JAN 2015), 'MONTH END'(31st JAN 2015) into numeric using treatas function, after that i will subtract the two numeric dates then i can easily get answer changing Aggregation to MAX in Properties Tab. but my problem is every month it will be automated, is there any way to do this in reports environment. Thanks, Teja Surapaneni.
... View more
