Creating Date Difference

[will.good]

Hi,

We are creating a workflow to aid with Absence Management and need to put a request on hold until 8 weeks before the end date of the absence

The end date is captured in custom 22

The easiest way I have thought to do this is by using the Calculate Working Date/Time node, but am unsure if this can calculate minus values?

 

This is how I have it set up where the start date is the end date variable - is this the best way to do this?

[Peter Clough]

The way I've done this when needed is to use the Get Timestamp utility (Service Manager > Application > Utility > Get Timestamp).

Calculating that against working time is, assuming 8 hours/day 5 days/week, going to turn into something closer to 6 months instead of 56 days.

You'd use the end date as the starting timestamp, operator would be Subtract, and the timeUnitDays would be 56, that should get you the time-stamp. Given it's an off-hold time, it might come off-hold during downtime, a weekend or something, but the SLA wouldn't continue to tick, at the least.

[Sam P]

I have the same scenario as you (starting timestamp is in the future, release x days before that date) and this is how my node is configured (note this is a Cloud Automation task which has since been migrated in to the Hornbill Automation node so may need some adjustment).  If you're processing lots of timestamps in the same Stage, its best to make your nodes unique by updating the result reference - here you can see I have appended ProcessOn, so that a) its easier for me to identify when using the variable picker and b) so that the Workflow knows which Timestamp to use.

[will.good]

Thanks both, this has worked a treat