locked
How to subtract time value only from DateTime field? RRS feed

  • Question

  • User1405704356 posted

    How could I subtract the "Time" Values while ignoring the "Date" values?

    Date and Time are not separate fields.

    table.aaTime               table.bbTime
    6/18/17 14:39             5/30/17 14:40

    How could I subtract 14:39 - 14:40 and ignore the date values?

    Thanks for any assistance

    Tuesday, August 1, 2017 5:33 PM

All replies

  • User2119946224 posted

    Hi,

    Please try to use "TimeSpan" for get values of date part. After that you can use different component to subtract and calculate based on 24 hrs and 60 minutes.

    Hope it helps you.

    Regards,

    Wednesday, August 2, 2017 7:01 AM