Hour 21Date Manipulation
An integral part to most business processes is date manipulation. Dates are important to business for a number of reasons. Virtually everything related to business is tied in some way to a date. From birth dates to expiration dates, dates affect business. Transaction dates track when transactions were created and applied. Payment due dates track when a payment is due or past due. Birth dates are used to determine age. Accounting systems use dates for reporting income and expense. In this hour, concepts relating to date manipulation are covered. The topics include
• Calendar history and the year 2000 problem
• Determining the current system date
Current-Date Intrinsic Function
• Finding the number of days between ...