LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Calculate minutes difference between two date/timestamps

    Employee
    Posted 07-24-2012 17:36

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: kevin_chuah

    Hi there,

    Can we have some assistance please on the following..

    Input looks like below and is in a STRING format

    MinDate,MaxDate
    2012-07-24 11:46:35,2012-07-24 12:00:52

    We'd like the output to be

    MinDate,MaxDate,MinutesDifference
    2012-07-24 11:46:35,2012-07-24 12:00:52,14

    thanks


  • 2.  RE: Calculate minutes difference between two date/timestamps

    Employee
    Posted 07-25-2012 08:47

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Tim Meagher

    Hi,

    I think you want to convert these two string formatted dates to a datetime format, using the timestamp operator.
    Then, you want to use the dateSubtract function.

    See the following post for an idea of how to get started:
    Compare months in Year-Month format

    Tim.