Skip to Content
0
Former Member
May 08, 2008 at 02:56 PM

Need to add new column in SAP Query - Please guide me in this regard

135 Views

Dear All,

In SAP Query, I need to put a new coulmn of each record for the difference of Billing date and PGI date as a work days.

eg: Billing Date = 02.05.2008

PGI Date = 08.05.2008

Take a Variable i.e. Days = Billing Date - PGI Date that will display as 5 days by excluding Saturday and Sunday.

After doing calculation of these work days for each record, we need a to add a new coulmn in that record as field lable as "Work Days" and display.

Please Guide me in this regard

Regards,

Sateesh.