Calculate date difference with Update process data

Follow

Ermin Dzankovic

• April 07, 2020 08:50

I have problem with Update process data. I can't calculate difference between two dates in years. I have put all my variables in DateTime format but I dont have any result ?

Formula in expression is

(((DateTime)(${/pd:AP/pd:processFields/pd:CurrentDateTime})).Year)-(((DateTime)(${/pd:AP/pd:processFields/pd:CurrentLicence/pd:CurrentSaleDatum})).Year)

0

• Official comment

  

  AgilePoint NX Support

  • April 11, 2020 12:10

  Ermin,

  Please try this way in Update Process data Activity and see if it helps your use case.

  (DateTime.Parse((${/pd:AP/pd:processFields/pd:CurrentDateTime}).ToString()).Year)-(DateTime.Parse((${/pd:AP/pd:processFields/pd:CurrentLicence/pd:CurrentSaleDatum}).ToString()).Year)

   

  Ideal solution is to use the OOTB Date manipulation Activities like 'Calculate Date Difference activity'.

  https://documentation.agilepoint.com/00/appbuilder/cloudenvShapeCalculateDateDifference.html#DateDifferenceInput

   

  

   

  Thank you

  AgilePoint NX Support

  Comment actions Permalink

Please sign in to leave a comment.