set value based on difference of 2 dates in confiform

[Markisio]

Hi there

want to set a value based on calculating 2 dates field, here is what I have

• Date field 1 = dateF1
• Date field 2 = dateF2
• Status field = status

I want to check if the difference between 2 dates are more than 3 days then set a value to status field to error. something like this 

Condition: !dateF1:[empty] AND !dateF2:[empty] AND ((([entry.dateF2.timestamp] - [entry.dateF1.timestamp])/86400000)>3)

Value to Set: status=error

Any insights is much appreciated 

[Alex Medved _ConfiForms_ · Accepted solution]

Hi

Consider using something like this

!dateF1:[empty] AND !dateF2:[empty] AND (dateF2.timestamp.subtract([entry.dateF1.timestamp]).divide(86400000):>3)

Alex

[Markisio]

works like a charm :) thanks @Alex Medved _ConfiForms_