Pending Age

[#1]

Need help on  pending Age:

Logic

for Aging: Call logged (SER_Received_DT) from 00 hrs to 12.59 hrs next day aging will be "1" and SER_Received_DT on and after 15 hrs aging should be "0". Next to next day "+1" should be added aging 1 will become "2"and 0 will become "1".

pls help on this...

[#2]

Pls explain with data.

Regards,

Kabilan K.

[#3]

Need pending Age in this way...

Example:

1.01.2013 day     call logging from  0 hrs to 12.59 hrs:1 day

                          after 13 hrs to 00.00 hrs:0 day.same it will add like below shown.

2.01.2013     

                           0 hrs to 12.59 hrs:2 day

                          13 hrs to 00.00 hrs:1 day

3.01.2013

                          0 hrs to 12.59 hrs:3 day

                          13 hrs to 00.00 hrs:2day

[#4]

If I am understanding ur requirement then follow below.

I think ur table like below.

Date             

01-01-2013 04:00:00

04-01-2013 14:00:00

Load Date

         ,Today()-Date+if(Date=today(),1,0)  As AM

         ,Today()-Date+if(time(Date,'hh.ss')>=13.00 and time(Date,'hh.ss')<=23.59,1,0) As PM

From Date table;

Hope it will help U.

Regards,

Kabilan K.