Has anyone tackled this before? I am trying to calculate the time
elapsed between two dates based on business hrs. It will be used to
build a report that tells us how long it takes to process an order.
Basically only M-F 8am-6pm counts. Using datediff uses a 24hr
calendar. I've looked
SQL also has it's own DateDif() fucntion.
-Original Message-
From: Botts, Tom [mailto:[EMAIL PROTECTED]
Sent: 06 March 2006 18:29
To: CF-Talk
Subject: Calculate the time elapsed between two dates based on business hrs
Has anyone tackled this before? I am trying to calculate the time
at 10AM I
would do (3 * 10) + 4 + 2 That is a simplified explanation of what I did,
hope it helps some.
On 3/6/06, Botts, Tom [EMAIL PROTECTED] wrote:
Has anyone tackled this before? I am trying to calculate the time
elapsed between two dates based on business hrs. It will be used to
build
different holidays.
[EMAIL PROTECTED]
Doug :0)
Has anyone tackled this before? I am trying to calculate the time
elapsed between two dates based on business hrs. It will be used to
build a report that tells us how long it takes to process an order.
Basically only M-F 8am-6pm counts. Using datediff
elapsed between two dates based on business hrs
Has anyone tackled this before? I am trying to calculate the time elapsed
between two dates based on business hrs. It will be used to build a report
that tells us how long it takes to process an order.
Basically only M-F 8am-6pm counts. Using datediff
5 matches
Mail list logo