WebNov 9, 2010 · To create a timestamp using a date/time object, you can use the syntax variant of the CONVERT statement shown in Listing 2.9. The date/time values are qualified using the TIME ZONE addition so that the appropriate offsets can be applied as the UTC timestamp is generated. WebWill 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. Try this FM - RH_GET_DATE_DAYNAME by passing language and date. You use the FM - DAY_IN_WEEK .. it will give u the day in number format Monday = 1, Tuesday = …
FM to calculate date. SAP Community
WebJan 21, 2008 · Use the FM, 'HR_HK_DIFF_BT_2_DATES' to find the number of months exists between the given 2 dates. See the following example... Data: d1 type sy-datum, d2 type sy-datum, wf_month_diff type P0347-SCRMM. call function 'HR_HK_DIFF_BT_2_DATES' exporting date1 = d1 date2 = d2 output_format = '04' … WebNov 22, 2007 · Hi All, Can any one specify the function module to add days to current date? e.g. if i add 7 days to 31st Jan, it should come as 7th feb, not 38 . Plz specify with example. green and gray color palette
Function Module related on Date calculations - SAP
WebDec 29, 2008 · no need to use the FM and all. just delete the from date - start date. you will get the number of days. Ex: 12/29/2008 - 11/29/2008. directly you will get the result. and also you need to check the holidays ( company dependent ) in that month and delete from the final result as well. hope it will useful to you. Add a Comment Alert Moderator WebFeb 28, 2024 · Solution: To achieve the solution, the below steps need to be followed: Convert the Year field to an integer, by using the below formula in a Calculated … WebDAYS = ( to_DATE (4) - from_date (4) ) * 360 + ( to_DATE 4 (2) - from_date 4 (2) ) * 30 + ( to_DATE 6 (2) - from_date 6 (2) ) But the calculation is wrong in some cases.like following: 1.The two dates are02/02/2007 - 3/05/2007 - the code resulted as … green and gray color scheme