Automation - Set a field to the difference between now and the start date

[Luke Twinney]

I am trying to use automation to improve our reporting by automatically setting a field to the total time spent on a ticket. I am trying to accomplish this by setting a field to be the difference between the start date and when the issue was resolved. I'm using seconds in my rule for the sake of testing.

The rule seems to be running successfully however the "Time to Resolved" field is still empty afterwards. Time to resolved is a Date Time Picker field.

I've attached screenshots showing the full rule. Any ideas why this isn't working? 

Thank you

[Ste Wright · Accepted solution]

Hi @Luke Twinney 

There's no screenshots in the question - could you attach these?

Ste

[Luke Twinney]

Hi Stephen,

Sorry about that, they're uploaded now.

Thanks,

Luke

[Ste Wright]

Hi @Luke Twinney 

This won't work with a Date Time Picker - it's expecting an actual date-based value - eg. DD/MM/YYYY hh:mm - rather than a numeric value.

You'll need to publish this value either...

• Into a number field, or...
• Into a short text field (it can be the read-only type)

Ste