Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Watson Watson

5th Edition

0471715360, 978-0471715368

More Books

Students also viewed these Databases questions

Question

How do Data Types perform data validation?

Answered: 1 week ago

Question

How does Referential Integrity work?

Answered: 1 week ago