Forum Discussion

Surendar's avatar
Surendar
Contributor
8 years ago

How to find date difference between two dates?

I need to find the date different between two dates. There is no option available for datediff in SnapLogic. I tried with minus function in expression but won’t work. date1 - date2 also won’t wo...
expression_language
pipeline
transform
Surendar's avatar
Surendar
Contributor
8 years ago
Copy LinkReport

Yes I have found the solution using the getTime() but its limited to date-time datatype. If suppose the datatype may vary facing undefined getTime issue for local-date-time and etc.

date difference:

Math.floor(($date1.getTime() - $date2.getTime() ) / (1000 * 60 * 60 * 24))

  • dmiller's avatar
    dmiller
    Former Employee
    8 years ago
    Copy Link

    I checked with Dev and historically we’ve seen people format the local time into a string and then do Date.parse().