I am trying to calculate a duration within an Automation, by reading two date and time stamps from a table, subtracting the end time from the start time and writing the result back into a Duration field in the same table. If I do this calculation within an App, it works fine, but if I try the same …

Hi Brian, Welcome to Tulip Community :tada: and thanks for your question! My first thought is something with the time conversion (for example, from ms to min is a conversion of 60,000). Are the two date stamps you are using the same units (ex. both in seconds) in app expression editor and automati…

Hi Beth, I have an Automation that monitors the change in a machine state, and records the start and end times of each uptime and downtime period in a table using the current date and time function within the Automation, so the date stamps are all sourced from the same place, so they should all be …

Brian, Thanks for the additional details here! I checked this with the Tulip product team, and this is indeed a bug. We have a ticket filed and are working on fix that will be in the next release (r278). Thank you for bringing your question and helping to point this out to us! I will follow up her…

Why is Date calculation in Automation giving a strange result

Support, Troubleshooting, & Help

Beth May 13, 2024, 8:02pm 5

This should now be resolved from Release 278 - April 2024! thanks for bringing it up @brian.petrie

Topic		Replies	Views
Tulip Dashboard Analysis: Display error when subtracting 2 dates Support, Troubleshooting, & Help apps	5	366	June 29, 2022
Calculations using the date-time data Support, Troubleshooting, & Help	1	508	October 30, 2019
Automation using expression with dates	4	284	May 5, 2024
Expression of duration in seconds Support, Troubleshooting, & Help devices	1	209	August 14, 2023
How to get number of days only? Support, Troubleshooting, & Help	2	80	September 11, 2024

Why is Date calculation in Automation giving a strange result

Related topics