Hi Dylan,
You can use Business Time to calculate the number of "business" seconds between
planned completion date and the current time. Stick the calculation in either a
filter, or triggered from an escalation, depending on what you're ultimately
aiming for. You would put the result in another field.
Regards,
Matt Willis
---- Dylan Thomas <[EMAIL PROTECTED]> wrote:
> I need to set a qualification based on weekdays and I've got myself brain
> locked on it. Looking for some help.
> I want to change a field if the planned completion date is less then 3
> weekdays from now. Not sure how to get that coded though?
>
> ('Planned Completion' - $TIMESTAMP$) < 345600
> I know that will get me 3 days from now, but if a weekend falls inbetween
> there it wont work. Maybe I'm overcomplicating it? heh
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
> Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
