Author Question: Describe the DateDiff, DateAdd, DateSerial, and DatePart functions, and give an example of each. ... (Read 72 times)

stevenposner

  • Hero Member
  • *****
  • Posts: 608
Describe the DateDiff, DateAdd, DateSerial, and DatePart functions, and give an example of each.
 
  What will be an ideal response?

Question 2

Lists are a series of paragraphs.
 
  Indicate whether the statement is true or false



tmlewis4706

  • Sr. Member
  • ****
  • Posts: 295
Answer to Question 1

The DateDiff function is used to determine the difference between two dates. Generally one date is obtained from a field, and the second date is obtained by using the Date function. Many instances exist in which you could use the DateDiff function. For example, suppose you have a form that you use to automatically refill customer prescriptions. In the Orders table, you have a field named Refill On that contains the earliest date that the prescription can be refilled. You can use the DateDiff function with a text box on the form to display the number of days left before the prescription can be refilled and shipped.
You can use the DateAdd function to add or subtract a specific time interval from a date. For example, you can use DateAdd to calculate a date 10 days from today or a time 30 minutes from now. Business professionals work with dates on a regular basis. A human resources manager may want to calculate when a newly hired employee is eligible for benefits, which is generally 90 days after the date of hire. Additionally, the human resources manager may want to calculate the earliest date an employee can retire.
To display specific dates, you can use the DateSerial function to manipulate the day, month, and year of a date. DateSerial is very flexible because you can manipulate each part individually or together in any combination that meets your needs. For example, when the human resources manager wants to prepare paperwork for an employee's retirement, the manager can use the DateSerial function to calculate 90 days prior to the employee's 65th birthday. Naturally, you would take the birthdate and add 65 years. Then take that date and subtract 3 months. Using the DateSerial function, you can do this in one step.
You can use the DatePart function to examine a date and return a specific interval of time. For example, you can use DatePart to calculate the day of the week for an order's ship date.

Answer to Question 2

TRUE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Hip fractures are the most serious consequences of osteoporosis. The incidence of hip fractures increases with each decade among patients in their 60s to patients in their 90s for both women and men of all populations. Men and women older than 80 years of age show the highest incidence of hip fractures.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Colchicine is a highly poisonous alkaloid originally extracted from a type of saffron plant that is used mainly to treat gout.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Certain topical medications such as clotrimazole and betamethasone are not approved for use in children younger than 12 years of age. They must be used very cautiously, as directed by a doctor, to treat any child. Children have a much greater response to topical steroid medications.

For a complete list of videos, visit our video library