Assuming a hire date of 7/31/2016,which of the following would be the correct DatePart Function for the correct day of the week?
A)DatePart("w",[HireDate])
B)DatePart("ww",([HireDate])
C)DatePart("y",[HireDate])
D)DatePart("m",(HireDate])

Question

Quizplus · Accepted Answer

The DatePart function with the argument "w" returns the weekday of the date, where Sunday is considered the first day of the week (so the range of possible results is 1 to 7). Therefore, using the function DatePart("w",[HireDate]) would return the correct day of the week for a hire date of 7/31/2016.

Assuming a Hire Date of 7/31/2016,which of the Following Would