Skip to Content
author's profile photo Former Member
Former Member

FM to get dates of week

hi,

i required to find first and last date of the week,

i have year(2008) and week(22) as input '200822'

i know this function modules:

DATE_GET_WEEK

WEEK_GET_FIRST_DAY

GET_WEEK_INFO_BASED_ON_DATE

LAST_WEEK

NEXT_WEEK

but my requirement, to get week's first and last date.

regards,

rajyalaxmi.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:15 AM

    hi,

    Use FM WEEK_GET_FIRST_DAY and pass '200822' as input to get the first day ...based on this you can calculate the last day ...i.e, + 5 days of that week will return the same

    Regards,

    Santosh

    Edited by: Santosh Kumar Patha on Jul 24, 2008 3:46 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:17 AM

    i know this FM it returns only first day, i required last date also

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:17 AM

    Hi Merugu,

    Try the FM:

    DAY_ATTRIBUTES_GET

    Return useful information about a day. Will tell you the day of the week as a word (Tuesday), the day of the week (2 would be Tuedsay), whether the day is a holiday, and more.

    With luck,

    Pritam.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:18 AM

    hi,

    try these fm

    FM LIST WITH RESPECT TO DAY, WEEK, AND MONTH.

    CALCULATE_DATE : Calculates the future date based on the input .

    DATE_TO_DAY : Returns the Day for the entered date.

    DATE_COMPUTE_DAY : Returns weekday for a date

    DATE_GET_WEEK : Returns week for a date

    RP_CALC_DATE_IN_INTERVAL : Add days / months to a date

    MONTHS_BETWEEN_TWO_DATES : To get the number of months between the two dates.

    END_OF_MONTH_DETERMINE_2 : Determines the End of a Month.

    HR_HK_DIFF_BT_2_DATES : Find the difference between two dates in years, months and days.

    FIMA_DAYS_AND_MONTHS_AND_YEARS : Find the difference between two dates in years, months and days.

    MONTH_NAMES_GET : Get the names of the month

    WEEK_GET_FIRST_DAY : Get the first day of the week

    HRGPBS_HESA_DATE_FORMAT : Format the date in dd/mm/yyyy format

    SD_CALC_DURATION_FROM_DATETIME : Find the difference between two date/time and report the difference in hours

    L_MC_TIME_DIFFERENCE : Find the time difference between two date/time

    HR_99S_INTERVAL_BETWEEN_DATES : Difference between two dates in days, weeks, months

    LAST_DAY_OF_MONTHS : Returns the last day of the month

    DATE_CHECK_PLAUSIBILITY :Check for the invalid date.

    reward points if useful,

    siri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:18 AM

    hi,

    Refer to the link.

    fm-to-get-the-date

    Regards

    Sumit Agarwal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:32 AM

    Can you check the following FM's

    HR_GBSSP_GET_WEEK_DATES

    HRWPC_BL_DATES_WEEK_INTERVAL

    Yes your requirement is different on year and week no you need to first and last dates of that week,..

    May you can find some useful info in the above function modules and will be useful to design some code to get the dates

    Thanks and regards

    Pushkar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 10:34 AM

    Hi Rajyalaxmi.

    I would like to suggest a few,

    First day -

    WEEK_GET_FIRST_DAY - Calendar function: Return first day for a week

    BWSO_DATE_GET_FIRST_WEEKDAY

    HRIQ_WEEK_GET_FIRST_DAY

    WEEKDAY_GET - Calendar: Get day of the week

    Last Day -

    TIME_GET_LAST_WEEK

    BKK_GET_DAY_OF_WEEK

    WEEKDAY_GET - Calendar: Get day of the week

    Hope that's usefull.

    Good Luck & Regards.

    Harsh Dave

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.