Skip to Content
avatar image
Former Member

Calculating First and Last date of a Calender month wise (Monday – Sunday)

Calculating First and Last date of a Calender month wise (Monday – Sunday) instead of fiscal year period

Please ping me the logic

KASI S

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 01, 2017 at 09:48 AM

    HI

    concatenate calendar month '01' to first_date

    last date = first date +35.

    concatenate last date (6) '01' to last date

    last date = last date - 1.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 02:50 PM

    you can use FM SLS_MISC_GET_LAST_DAY_OF_MONTH to get the last day.

    Add comment
    10|10000 characters needed characters exceeded