Question: Your data contains two datetime fields: Invoice _ Date and Approval _ Date. Your objective is to calculate the number of hours between the two

Your data contains two datetime fields: Invoice_Date and Approval_Date. Your objective is to calculate the number of hours between the two dates, to two decimal places. For example, if the Approval_Date appears in Analytics as OcU29/201309:47:44 and the Invoice_Date appears as OcU25/201311:17:44, you want the result to be 94.50. What is the correct expression syntax to achieve this?
A.
(Approval_Date - Invoice_Date)*24
B.
ROUND(( Approval_Date - Invoice_Date)*24)
C.
DEC(( Approval_Date - Invoice_Date)*24,2)
D.
HOURS( Approval_Date - Invoice_Date)
E.
HOURS(( Approval_Date - Invoice_Date)*24)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!