07-24-2008 11:11 AM
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.
07-24-2008 11: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
07-24-2008 11:17 AM
i know this FM it returns only first day, i required last date also
07-24-2008 11: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.
07-24-2008 11: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
07-24-2008 11:18 AM
07-24-2008 11: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
07-24-2008 11: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