Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Date Difference between two datetime fields in confiform

Dhiraj Kr_ Gupta
Contributor
December 18, 2024
  • I have two confiform datetime fields Date1 and Date2 and another confiform date time interval field as Datediff.

I want to get the date difference between Date1 and Date2 in the field Datediff.

I am using IFTTT but not getting the result as error showing End Date Missing.

IFTTT used

entryId=[entry.Id]&Datediff=([entry.Date1]-[entry.Date2])

 

Lastly I want 

entryId=[entry.Id]&Datediff=([entry._now]-[entry.created])

How can I do this

1 answer

Suggest an answer

Log in or Sign up to answer
0 votes
Alex Medved _ConfiForms_
Community Champion
December 18, 2024

Datediff is a date time interval field?

what you have now is that you calculate the milliseconds between Date1 and Date2 (assuming Date1 is AFTER the Date2)

Date time interval expects you to provide the startDate and the endDate as a value, in the format of 

[entry.Date1]-[entry.Date2]

 (not a calculated value)

But a timestampForStart-timestampForEnd

TAGS
AUG Leaders

Atlassian Community Events