06-30-2007 4:53 AM
hi experts,
cud u plz tell me about the function module in which if i enter the start and enddate it will give me <b><u>number</u></b> of sundays in between the dates..thnx in advance...
06-30-2007 5:04 AM
Hi Ravi,
Implement this.
For No of Sundays & Saturdays
date1 LIKE sy-datum DEFAULT '20060501',
date2 LIKE sy-datum DEFAULT sy-datum.
DATA z TYPE p DECIMALS 0.
DATA cnt TYPE sy-dbcnt.
WRITE: date1, date2.
WHILE date1 LE date2.
CALL FUNCTION 'DAY_IN_WEEK'
EXPORTING
datum = date1
IMPORTING
wotnr = z.
ADD 1 TO date1.
IF z = 7.
ADD 1 TO cnt_su.
ENDIF.
ENDWHILE.
WRITE: / 'Sun:', cnt_su.
Reward if useful.
Thanks
Aneesh.
06-30-2007 5:04 AM
Hi Ravi,
Implement this.
For No of Sundays & Saturdays
date1 LIKE sy-datum DEFAULT '20060501',
date2 LIKE sy-datum DEFAULT sy-datum.
DATA z TYPE p DECIMALS 0.
DATA cnt TYPE sy-dbcnt.
WRITE: date1, date2.
WHILE date1 LE date2.
CALL FUNCTION 'DAY_IN_WEEK'
EXPORTING
datum = date1
IMPORTING
wotnr = z.
ADD 1 TO date1.
IF z = 7.
ADD 1 TO cnt_su.
ENDIF.
ENDWHILE.
WRITE: / 'Sun:', cnt_su.
Reward if useful.
Thanks
Aneesh.