Forum Discussion
Using Datediff but date and time data split
Hi,
I had split my date/time columns for some calculated columns earlier, but, now, I've been asked to calculate difference between two dates, and for this I need both date and time. Is this possible to use datediff without having to rejoin these values back? I need to determine if a close date happens within 24 hours of the open date - so need to know both days and hours. Is it possible in one formula to create a calculated column to determine the real # of hours between 4 columns? (1. date and time fields when opened, and 2. date and time fields when closed)?
Thanks,
Rob
I woulodn't have thought you'd have need to rejoin anything - the only time you need to be concerned about the time is if the start and end dates are precisely one day apart. Just go for a comparison like:
if (end date - start date) >=2 then "not within 24 hours", else
if (end date - start date) = 1 and (end time > start time) then "not within 24 hours" else "within 24 hours"
2 Replies
I woulodn't have thought you'd have need to rejoin anything - the only time you need to be concerned about the time is if the start and end dates are precisely one day apart. Just go for a comparison like:
if (end date - start date) >=2 then "not within 24 hours", else
if (end date - start date) = 1 and (end time > start time) then "not within 24 hours" else "within 24 hours"
That makes total sense.. I'll give that a try when I'm done meetings today and see if it comes out right.
Thanks!
