Skip to Content
0
Former Member
Feb 25, 2009 at 07:34 AM

Designing Query.

28 Views

Hi,

In want to design query in which i want to get count of number of orders which falls into buckets(<5 days ,5-10 days,10-15 days,15-20 days) based on age(age = present system date - required date(key figure)) .

For that i created formula for Age = present date - required date.

from the age i am not getting how to count the orders which fall into respective bucket.

Thanks in Advance.

With regards

KPS Moorthy