Legacy Dev Forum Posts

 View Only

Sign Up

Calculate the difference between two dates in Architect

  • 1.  Calculate the difference between two dates in Architect

    Posted 06-05-2025 19:12

    mostafa.oudderhem | 2022-11-11 15:36:37 UTC | #1

    Hi,

    I need the expression to calculate the difference between the "current_date" and another date returned by an external Web Service (with format: yyyy-mm-dd ) in order to obtain the number of days as difference in Architect.

    Thank you in advance for you help.

    Regards.


    Kevin_Walsh | 2022-11-18 10:21:30 UTC | #2

    Hello,

    Apologies for the delay in getting back to you. I think we can do this using the following expressions: DateDiff & ToDate, e.g.

    DateDiff(MakeDate(Year(GetCurrentDateTimeUtc()), Month(GetCurrentDateTimeUtc()), Day(GetCurrentDateTimeUtc())), ToDate("2009-01-10"))

    Hope the above helps.

    Regards,

    Kevin


    system | 2022-12-19 10:22:22 UTC | #3

    This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.


    This post was migrated from the old Developer Forum.

    ref: 17185