Question: DateValue is a date column that contains the posting date of transaction. A query should label each transaction based on how many days have elapsed
DateValue is a date column that contains the posting date of transaction. A query should label each transaction based on how many days have elapsed since the transaction was posted. The requested ranges are
days
days and greater than
days How does the following CASE state fail to label the transcations appropriately? CASE WHEN DATEDIFFd DateValue, CURRENTTIMESTAMP THEN days'
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
