Calculate date difference with Update process data

追蹤

Ermin Dzankovic

• 2020年04月07日 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

• 正式評論

  

  AgilePoint NX Support

  • 2020年04月11日 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

  評論操作 永久連結

請登入寫評論。