Forum Discussion

ArchStanton's avatar
ArchStanton
Icon for Power Participant rankPower Participant
3 years ago
Solved

Calculating Working Days between multiple events

Hi, I would like to calculate the Working Days only for a Case between Received and Resolved dates. This is easy if it was just that simple because occasionally a Case can be put on hold (deferred) ...
Need Help
Show and Tell
  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    3 years ago

    This is exactly what I needed, thank you so much!!!

  • ArchStanton's avatar
    ArchStanton
    Icon for Power Participant rankPower Participant
    3 years ago

    Hi,

    Quick question, there have been a few occurences where there are even more Deferred Start & End Dates, I have one with 4 different dates so 4 rows in the deferral table. Is it possible to modify this code to COUNTROWS of each ID to factor in these multiple scenarios?

    The code works just fine with 2 row as per example you have provided, its just falls down when there are more than 2.

    Thanks