Calculate the number of days between dates

Tom Santiago

This article explains how to use handlebars helpers to calculate the number of days between dates.

21*24*60*60 = 1814400 = seconds in 21 days.

timestamp:

{{timeStamp}}

date+offset:

{{dateAdd myDate 1814400000}} //dateAdd uses milliseconds

timeStamp in seconds from epoch:

{{dateFormat 'X' timeStamp}}

myDate in seconds from epoch:

{{dateFormat 'X' myDate}}

myDate in seconds + 21 days:

{{add 1814400 (dateFormat 'X' myDate)}}
{{#compare (add 1814400 (dateFormat 'X' timeStamp)) ">" (dateFormat 'X' myDate)}}

21 days from now is greater than myDate

{{else}}

21 days from now is less than myDate

{{/compare}}

Comments

4 comments

Vamshi Reddy

August 25, 2023 09:48
Tom Santiago,

I only found adding number of days to the original dates, Can you help in figure out how to compare two dates and the difference in days?
0
Tom Santiago Principal Technical Writer Community moderator

August 25, 2023 20:43

Edited
Vamshi Reddy,

Can you try this solution to help you resolve that issue?

https://docs.celigo.com/hc/en-us/community/posts/360078072592-Comparing-NOW-date-function-
0
ellan reddy

August 31, 2023 00:45
I’m receiving the error: “Missing Helper: dateAdd”
0
Stephen Brandt Documentation Manager Community moderator

August 31, 2023 17:43
Sorry, ellan reddy. Could you share the full statement for us to try to troubleshoot?
0

Please sign in to leave a comment.