Workflow for calculating difference between two dates

[camille]

Hello,

I'm trying to calculate the difference between two dates as seen in the screenshots below.

Once the Preview Date and Approval Date are 'not empty', I want the difference between the two dates to be calculated and inputted into the field ReviewPhaseLength.

What I currently have isn't displaying any results - can someone point me in the right direction? I'm not a developer so I thought making a workflow for this would be easiest.

Thank you in advance!!

Camille

[yuri]

Hi Camille,

The first mistake I noticed, "days" should be quoted: 'days'. It' should be a string.

[camille]

Hi Yurikuzn,

Thank you! I've made this change - it still hasn't updated the field but I think we're on the right track.

[yuri]

You need to remove the field (in the action definition) and leave only formula.

reviewPhaseLength = datetime\diff( ... )

[camille]

Awesome, it's working now. Thank you!