Skip to main content
M
manikumarib1567
January 7, 2025
Solved

Time difference between two date times

  • January 7, 2025
  • 2 replies
  • 0 views

Hi Team,

I have a requirement , where I need to find the time difference between two date times. I am facing one issue, I have to find the difference in EST timing, day start should be at 8 am and day ending will be on 8pm. when I am using callworkminutesplugin() function, it is not giving proper result as when it was converting time to EST it is giving diffirennt result in expression. Please help in getting the minutes difference in 2 date times.


the above time is returning fn!datetime(2025, 1, 7, 10, 21, 35, 230) in expression. Why is this so?

[mention:b8ea18cfbb2e4f6d841cf3c1d4d7420b:e9ed411860ed4f2ba0265705b8793d05]  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  [mention:2df2892a4df7486f9775b4d2f0e405fd:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05]  [mention:dea33493db6342c9a73dc108d45120c0:e9ed411860ed4f2ba0265705b8793d05] 

@mathieud0001

    Best answer by stefanhelzle0001

    datetime() creates takes the values as if it is in the UTC timezone, then translates it into your time zone to display it. If you use the userdatetime() function, then the result is directly in your time zone.

    https://appian.rocks/2023/02/13/working-with-time-in-appian/

    2 replies

    stefanhelzle0001
    stefanhelzle0001Answer
    January 7, 2025

    datetime() creates takes the values as if it is in the UTC timezone, then translates it into your time zone to display it. If you use the userdatetime() function, then the result is directly in your time zone.

    https://appian.rocks/2023/02/13/working-with-time-in-appian/

      M
      manikumarib1567Author
      January 7, 2025

      Thank you [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] , This shows the solution to my issue.

      Terms & ConditionsAccessibility statement