Forum Discussion

kumar25's avatar
kumar25
New Contributor II
2 years ago
Solved

Difference between 2 dates

Hi, I have 2 dates, which are of localdatetime. Date1 - 2023-08-13T14:17:00.000 Date2 - 2023-08-23T05:00:00.000 I am using the below expression find the difference between them, and i am getting ...
  • koryknick's avatar
    koryknick
    2 years ago

    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!

abirenzi's avatar
abirenzi
New Contributor II
4 years ago

Hi @sjakathi,

Were you able to resolve it? I’m trying to combine 3 different fixed width files in 1 one, any idea on how to accomplish this?

heidi_andrew's avatar
heidi_andrew
Contributor
3 years ago

i am also working on a similar file but i do not know what snap to use to get it to file writer. i have tried document binary, fixed formatter but neither produce a populated file.

  • tlikarish's avatar
    tlikarish
    Employee
    7 years ago

    You can actually set the target field dynamically using a pipeline parameter, but maybe was hard to find in the documentation.

    Here is an example that I think will get you on the right track. In this example, the Group By N snap is used like you mention. I set the value to the pipeline parameter _TABLE, which has the value my-table. To do so, use the syntax $[(<pipe param>)] where <pipe param> is the pipeline parameter you want to use, so in this case $[(_TABLE)]. In the preview data, you can see that all documents were aggregated under the value my-table.

    • SriVinayaga's avatar
      SriVinayaga
      New Contributor II
      7 years ago

      @tlikarish,

      Thank you very much for your response. This is indeed helpful and worked as expected. This should be added to the documentation.

      Thanks and regards,
      Sri