Need Help??

[paulwalker]

Hi Community,

How to calculate Bucket based on date

(0-30 days, 30-60 days, 60-90 days and Above 90 days) but based on Date Field

I need only 0-30, 31-60, 61-90, Above 90......

suppose i have 2012, 2013, 2014 years data

if i am click 2012 i want to show this year data  (0-30, 31-60, 61-90, Above 90......)

same as 2013 and 2014

by default current year data..

Here 0-30 days means (suppose today 9/18/2014 = back 30 days means 8/20/2014)

see like this

9/18/2014

9/17/2014

9/16/2014

9/15/2014

9/14/2014

9/13/2014

9/12/2014

9/11/2014

9/10/2014

9/9/2014

9/8/2014

9/7/2014

9/6/2014

9/5/2014

9/4/2014

9/3/2014

9/2/2014

9/1/2014

8/31/2014

8/30/2014

8/29/2014

8/28/2014

8/27/2014

8/26/2014

8/25/2014

8/24/2014

8/23/2014

8/22/2014

8/21/2014

8/20/2014

Hope you Understand...same as 31-60, 61-90 and Above 90  (Above 90 means 91 days to 365 days)

please help me...

[qv_testing]

Hi Amit,

I need one more help...

suppose i have a Days.. like..

These are my input fields...

Ex:    Start_day                 End_Date

           10                            30

           31                            45

           45                            60                                  Generate Report

If i am click generate report button i want to generate report based on input dates....  Customer and SalesPerson standard fields...

Like this

Custmer            SalesPerson           10-30 days      31-45 Days      45-60 Days       61 to MaxDays

XXX                     AAAA                      10000             2000                  5890                   3300000

ABVB                    ABC                           230             4500                  790                     5000000

is this possible............??