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_

Hi

Consider using something like this

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

Alex