Saturday, June 12, 2010

Function Modules related to Date and Time Calculations

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
DAY_ATTRIBUTES_GET Returns attributes for a range of dates specified
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.
DATE_2D_TO_4D_CONVERSION Year entry: 2-character to  4-character.
DAY_IN_WEEK Input date and will give the name of the day 1-monday,2-Tuesday....
SD_DATETIME_DIFFERENCE Give the difference in Days and Time for 2 dates

1 comment:

  1. Dear Freelancer,

    We are very happy to introduce our self proudly http://hyderabadtrainingsads.com/ leading online free advertisement portal for software professionals and Business clients. We provide the complete freelancing projects information to worldwide from our clients.

    We are introducing new concept post your technical article in our portal free of cost. The main advantage of this article is we are publishing your contact details, ultimately you will get benefit without third-party.

    Happy To Post and Enjoy Benefit

    How to post your Article:-

    Click on the following link http://hyderabadtrainingsads.com/post-article/
    And post your Article.

    For Demo click here http://hyderabadtrainingsads.com/article/

    Thanks & Regards,
    Team info@hyderabadtrainingsdas.com
    http://hyderabadtrainingsads.com/

    ReplyDelete