Calculate the number of days between dates

Tom Santiago
  • Updated

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}}

Related articles

Comments

6 comments

Date Votes
  • Vamshi Reddy

    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
    • Edited
    Engaged
    Top Contributor
    Celigo University Level 4: Legendary

    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

    I’m receiving the error: “Missing Helper: dateAdd”

    0
  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    Sorry, ellan reddy. Could you share the full statement for us to try to troubleshoot? 

    0
  • ellan reddy

    Stephen Brandt - Basically, I need to add 2 years to the 'Last Modified Date'. I did follow the above provided syntax, but running into issues. Can you please help me out here?

    0
  • Stephen Brandt Documentation Manager Community moderator
    Celigo University Level 4: Legendary
    Engaged
    Great Answer
    Top Contributor

    ellan reddy, is the handlebars statement failing to calculate as intended, or are you getting a design-time or runtime error? Perhaps you could post a screen capture here or paste in the error message. 

    0

Please sign in to leave a comment.