Forum Discussion

jfpelletier's avatar
jfpelletier
Contributor
2 years ago
Solved

Converting Snowflake Lookup results into an array

Hello all, I'm using the Snowflake Lookup snap to query a table that contains the details of projects already processed, and get the values of the "project ID" column. The values are unique project ...
  • Vamsik's avatar
    Vamsik
    3 years ago

    Working now using MYSQL snaps

koryknick's avatar
koryknick
Employee
2 years ago
Copy LinkReport

kumar25 - This will first strip off the portion of your string that contains the timestamp, then perform the date difference, and finally convert from milliseconds to day.

(Date.parse($Date2.substr(0,10)) - Date.parse($Date1.substr(0,10)))
/ (1000 * 3600 * 24)

 Hope this helps!

  • jfpelletier's avatar
    jfpelletier
    Contributor
    2 years ago
    Copy Link

    Hello Abhishek_Soni37,

    Thanks a lot for your help, it resolved my problem the way I wanted. This is something I will probably re-use a lot, super useful for me! 🙂

    Kind regards,

    JF