| Author |
Message |
MFORD
Newbie
Joined: 13 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
  
Topic: DATE DIFFERENCE
Posted: 13 Mar 2008 at 6:52am |
|
Can someone provide me with a time difference formula to calculate time of days in between random dates....ex.the amount of time in between a rec'd date and a closed date not including Saturday & Sunday?
|
|
MF
|
 IP Logged |
|
|
|
MaddMatt
Newbie
Joined: 18 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 17
|
Posted: 14 Mar 2008 at 6:06am |
Hi,
The way I do it is lifted straight from the CR help files...
datevar d1;
datevar d2;
d1 := {recievedDate};
d2 := {closedDate};
DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday)
Hope that helps.
Cheers,
Matt
|
|
There are 10 types of people. Those that understand binary, and those that don't.
|
| IP Logged |
|
MFORD
Newbie
Joined: 13 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
Posted: 14 Mar 2008 at 6:29am |
|
Thanks Matt
I have tried that-it does not work, tells me that a date is required???? I'm at a loss.
|
|
MF
|
| IP Logged |
|
MaddMatt
Newbie
Joined: 18 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 17
|
Posted: 14 Mar 2008 at 6:36am |
Hi,
Sound to me like you've got DateTime fields there. Change you formula to this:
datevar d1;
datevar d2;
d1 := date({recievedDate});
d2 := date({closedDate});
DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday)
|
|
There are 10 types of people. Those that understand binary, and those that don't.
|
| IP Logged |
|
MFORD
Newbie
Joined: 13 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
Posted: 14 Mar 2008 at 6:45am |
|
That actually was accepted as a good formula then I pasted it into my details and it says bad date format string - you're so close!!!!
|
|
MF
|
| IP Logged |
|
MaddMatt
Newbie
Joined: 18 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 17
|
Posted: 14 Mar 2008 at 6:52am |
|
Just checking, but you are replacing {recievedDate} and {closedDate} with your actual database fields, aren't you?
|
|
There are 10 types of people. Those that understand binary, and those that don't.
|
| IP Logged |
|
MFORD
Newbie
Joined: 13 Mar 2008
Location: United States
Online Status: Offline
Posts: 6
|
Posted: 14 Mar 2008 at 6:57am |
|
Here is the formula that I am using:
datevar d1;
datevar d2;
d1 := date({CallLog.RecvdDate});
d2 := date({CallLog.ClosedDate});
DateDiff ("d", d1, d2) -
DateDiff ("ww", d1, d2, crSaturday) -
DateDiff ("ww", d1, d2, crSunday)
|
|
MF
|
| IP Logged |
|
MaddMatt
Newbie
Joined: 18 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 17
|
Posted: 14 Mar 2008 at 7:07am |
|
What version are you using?
|
|
There are 10 types of people. Those that understand binary, and those that don't.
|
| IP Logged |
|
MaddMatt
Newbie
Joined: 18 Feb 2008
Location: United Kingdom
Online Status: Offline
Posts: 17
|
Posted: 14 Mar 2008 at 7:17am |
Actually, it doesn't seem to matter what version you are using, the formula syntax doesn't appear to have changed at all.
A date format string is something like "ddMMyyyy", like you'd use in a cdate formula. Are you certain that it is this formula giving you the error?
|
|
There are 10 types of people. Those that understand binary, and those that don't.
|
| IP Logged |
|
|
|
