Calculate the difference between two dates in Architect

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.

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

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