Dates in pipeline

Question

Hi,
Im trying to write an if/and statement in SnapLogic. I need 2 dates to be compared to a third date. The issue is its turning my dates into a formula instead of recognizing it as a date. Any suggestions on how to get around this? I have it written out as 6/15/2017. I tried July 15, 2017 but that didn’t work.

tstack · Answer

smajor:

Im trying to write an if/and statement in SnapLogic. I need 2 dates to be compared to a third date. The issue is its turning my dates into a formula instead of recognizing it as a date. Any suggestions on how to get around this? I have it written out as 6/15/2017. I tried July 15, 2017 but that didn’t work.

Can you include the expressions that you are trying?  Are you using Date.parse() to convert the string into a Date object?
The following is working for me:
Date.parse("6/15/2017")

After you have the Date objects, you should be able to compare them with the usual comparison operators (e.g. less-than, greater-than, …).  For example, to compare a date against the current time:
$mydate &lt; Date.now() ? "past" : "future"

Forum Discussion

Dates in pipeline

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?