===== Function Module related on Date calculations ===== Directly from SCN. ^ Function Modules^ Description^ | /SAPNEA/J_SC_CONVERT_DATE| Covert Date in Japanese Format| | /SDF/CMO_DATETIME_DIFFERENCE| Calculates difference between two dates/timestamps.| | ADD_TIME_TO_DATE| Add time to date| | BKK_ADD_MONTH_TO_DATE| Add months to date| | BKK_ADD_WORKINGDAY| | | BWSO_DATE_GET_FIRST_WEEKDAY| Gives the First date of the week for the given date| | CACS_DATE_GET_TIMESTAMP| Concatenates the date and time format 11-12-2008 10:11:11| | CACS_DATE_GET_YEAR_MONTH| Gives the Year and month for the given date| | CACS_TIMESTAMP_GET_DATE| Get date and time from Timestamp| | CONVERT_TIME_TERMS| | | DATE_CHECK_WORKINGDAY| Check the day is working day or not for given date & calendar id| | DATE_CHECK_WORKINGDAY_MULTIPLE| Check the day is working day or not for given date in muliple calendar id| | DATE_COMPUTE_DAY| Gives the day number in the week (EX 1-Mon,2-TUE etc)| | DATE_CONVERT_TO_WORKINGDAY| | | DATE_TO_DAY| Gives the day of the date(Ex Monday, Tuesday etc)| | DATE_TO_DAY| Get the day of the date (Ex Mon.Tue etc)| | F4_DATE| FM for F4 help for Date| | FIMA_DAYS_AND_MONTHS_AND_YEARS| | | FIMA_DECIMAL_MONTHS_AND_YEARS| Gives the difference between the dates in decimal foemat of number of month & years| | GET_WEEK_INFO_BASED_ON_DATE| Get the week Number, Sunday date & Monday date for the given date| | HR_99S_DATE_ADD_SUB_DURATION| Add/Subtract months(M)/days(D)/years(Y) to given date to get the future date| | HR_99S_DATE_MINUS_TIME_UNIT| Subtract months(M)/days(D)/years(Y) to given date to get the future date| | HR_99S_DATE_PLUS_TIME_UNIT| Add months(M)/days(D)/years(Y) to given date to get the future date| | HR_99S_INTERVAL_BETWEEN_DATES| Gives the difference between the dates in days, weeks, years| | HR_99S_MONTHS_BETWEEN_DATES| Returns months between two dates. Both dates are included in the computation. An individual prorata is made for each month. \\ Meaning of parameter p_compl: \\ 'B' accumulate all complete months and in/complete first month. \\ 'E' accumulate all complete months and in/complete last month. \\ ' ' accumulate all months (incomplete and complete). \\ 'X' accumulate only complete months| | HR_CALC_YEAR_MONTH_DAY| Gives the difference between the dates in days, weeks, years| | HR_E_NUM_OF_DAYS_OF_MONTH| Number of days in the given month| | HR_HCP_ADD_MONTH_TO_DATE| Add months to date| | HR_IN_GET_DATE_COMPONENTS| Splits rge given date in DAY, MONTH, YEAR, Month Small TEXT & Month Long TEXT| | HR_MONTHS_BETWEEN_TWO_DATES| Gives months bteween the two dates| | HR_SGPBS_YRS_MTHS_DAYS| Gives the difference between dates in Day,Months, years 7 calendar Days| | HRAR_SUBTRACT_MONTH_TO_DATE| Subtract's one month from the date| | IDWT_READ_MONTH_TEXT| Read the month Text| | LAST_WEEK| Get the Last week Number, Sunday date & Monday date for the given Year and Week number| | LOOK_FOR_TIME_TABLE| | | MONTH_NAMES_GET| Gives the list of 12 months text in the given language| | MONTH_PLUS_DETERMINE| Add months to date| | MONTHS_BETWEEN_TWO_DATES| Gives months bteween the two dates| | MONTHS_BETWEEN_TWO_DATES_NEW| | | NEXT_WEEK| Get the Next week Number, Sunday date & Monday date for the given Year and Week number| | NUMBER_OF_DAYS_PER_MONTH_GET| Gives you the number of days per month considering the Year| | OIL_LAST_DAY_OF_MONTH| Gives the last day of the month| | OIL_LAST_DAY_OF_PREVIOUS_MONTH| Gives the last day of the prevous month| | OIL_MONTH_GET_FIRST_LAST| Gives the month first day date & last day date| | RE_ADD_MONTH_TO_DATE| Add months to date| | RH_GET_DATE_DAYNAME| Gives the day number in the week and day text| | RH_PM_CONVERT_DATE_TO_MONTH| | | RH_PM_CONVERT_DATE_TO_MONTH| Gives the difference between the dates in month| | RH_PM_CONVERT_DATE_TO_YEAR| | | RP_CALC_DATE_IN_INTERVAL| To calculate the new date by adding/Sub days, months & Year| | SG_PS_GET_LAST_DAY_OF_MONTH| Last day of the month| | TIME_CONVERSION| | | TM_DATE_CHECK_WORKINGDAY| | | WDKAL_DATE_ADD_FKDAYS| | | DATE_CHECK_PLAUSIBILITY| | | DATE_IN_FUTURE| Calculate Future Dates| | DURATION_DETERMINE| Calendar: Determine duration between tw| | DELTA_TIME_DAY_HOUR| Difference Between Date & Time| | CALCULATE_DATE| Year entry: 2-charact. to| | HR_SEN_CRULE_0100_DATE| Calculation of a Date (1 Year = 12 Months, 1 Month = 30 Days)| | DATE_2D_TO_4D_CONVERSION| |