Function Modules related on Date calculations

By Avinash Kodarapu

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