Time Calculation Handlebar Help

Integrator.io
1

I have the following Handlebar that calculates the number of hours worked on a job. (Trust me it works). v_NS_Time is populated by a result mapping in a previous step.

{{divide v_NS_Time 87.5}}

Now I want to use this value to calculate an ending date/time field.

Previously I was defaulting an end date/time to 1/2 hour with the following Handlebar

{{dateAdd (timestamp) "1800000"}}

When I try to replace the "1800000" with "360000" multiplied by the handlebar above, then nothing gets mapped as I want it to be. Here is the handlebar that I tried.

{{dateAdd (timestamp) {{multiply 3600000 {{divide v_NS_Time 87.5}}}}}}

Thanks for any help.

2

try this:

{{dateAdd (timestamp) (multiply 3600000 (divide v_NS_Time "87.5"))}}

The image shows a Playground interface for editing and previewing a Handlebars template using a JSON record. (Captioned by AI)
The image shows a Playground interface for editing and previewing a Handlebars template using a JSON record. (Captioned by AI)2200×466 56.8 KB

Let us know if it works, thank you!

1 Like
3

That worked great and it actually didn't need the quotes around the 87.5 value.

Thank you..

1 Like