XI - formula question

[campia]

Hi,

To find out how many days I needed to solve my ticket, I use this formula:

Select Case DateDiff("d",{Object.Creation Date}, {Object.Solved Date})
Case 0
formula="Same Day"
Case 1 to 5
formula="1day-5days"
Case 5 to 10
formula="5days-10days"
Case 10 to 15
formula="10days-15days"
Case 15 to 20
formula="15days-20days"
Case Else
formula="over 20days"
End select

How can I avoid to count Saturday and Sunday too?

andré

 

[IanWaterman]

use the function dayofweek(datefield) it will return 1 and 7 for sunday and saturday. You can then exclude these form your formulae.

Ian

 

[campia]

excuse me but where exactely should I put this formula, inside the "select"?

 

[IanWaterman]

Sorry no you will need to modify your date diff formula. On thinking about it it is more complex than I thought.
Please see Ken Hamady's solution:

http://www.kenhamady.com/form01.shtml

I have used it and it works well.

Ian

 

[campia]

I changed my formula:
Select Case (DateDiff("d",{Object.Creation Date}, {Object.Solved Date}) - DateDiff("ww",{Object.Creation Date}, {Object.Solved Date},crSaturday)- DateDiff("ww",{Object.Creation Date}, {Object.Solved Date},crSunday))

and it works.
Thanks