Original Message:
Sent: 01-21-2025 21:52
From: Matsumoto Shun
Subject: Converting ISO8601 format time to integer seconds
Hello Nathan,
Thanks for the reply.
I tested with the ToInt() function and it returned the expected value. Thank you very much.
I have no problem closing this question.
------------------------------
Matsumoto Shun
Unknown
Original Message:
Sent: 01-21-2025 07:29
From: Nathan Tossens
Subject: Converting ISO8601 format time to integer seconds
Hello Matsumoto,
did you try with the ToInt() function? Converts a Duration to an Integer. Returns an Integer value equal to the Duration in milliseconds
You can also simplify your formula to ToInt(DateTimeDiff(GetCurrentDateTimeUtc() ,Flow.StartDateTimeUtc)) I think.
I hope it helps.
Kind regards,
Nathan
------------------------------
Nathan Tossens
Original Message:
Sent: 01-21-2025 03:58
From: Matsumoto Shun
Subject: Converting ISO8601 format time to integer seconds
Hello Everyone
The DateTimeDiff function is used within Architect to calculate the conversation time.
The expression within the update action for the current data is as follows
→ToDuration(DateTimeDiff(ToDateTime(GetCurrentDateTimeUtc()), ToDateTime(Flow.StartDateTimeUtc)))
The default value returned by this expression is in ISO8601 format, as in "PT1M8.946".
How do I convert this to integer seconds?
Example: PT1M8.946 → 68 seconds
Best regards,
#API/Integrations
#ArchitectureandDesign
------------------------------
Matsumoto Shun
Unknown
------------------------------