Forum Discussion

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

Get MIN (oldest) or MAX (most recent) date from array of dates

Hi, I first do an SQL Server - Execute and get this weird {_snaptype_localdatetime: "..."} for the CreationDate and LastUpdate fields. Then, using a Mapper snap I do toString() to just get the date ...
Expression Language and Expression Libraries
  • j_angelevski's avatar
    j_angelevski
    3 years ago

    @ykoppisetty

    It is because the parse method expects a number but you are providing a string value.
    You need to parse the “Modified_Date”, you can do so by using parseInt(string).

    In your case would be:

    parseInt($Modified_Date)

    And the full expression to format the date would be:

    Date.parse(parseInt($Modified_Date))
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago
Copy LinkReport

The document contains multiple sheets or just one, and does it have any headers?

  • j_angelevski's avatar
    j_angelevski
    Contributor III
    3 years ago
    Copy LinkReport

    @ykoppisetty

    It is because the parse method expects a number but you are providing a string value.
    You need to parse the “Modified_Date”, you can do so by using parseInt(string).

    In your case would be:

    parseInt($Modified_Date)

    And the full expression to format the date would be:

    Date.parse(parseInt($Modified_Date))
  • j_angelevski's avatar
    j_angelevski
    Contributor III
    3 years ago
    Copy LinkReport

    Hi @ykoppisetty

    You can use the Date.parse() function.
    You need to pass the unix timestamp as a parameter.

    Input

    Date.parse(1445910469510)

    Output

    2015-10-27T01:47:49.510 Etc/UTC

  • ykoppisetty's avatar
    ykoppisetty
    New Contributor II
    3 years ago
    Copy LinkReport

    Hi @j.angelevski can you tell how to get dynamically?

    For example, the below field contain all the UNIX date formats so how to get normal date formats dynamically?

    Modified_Date
    1445910469510
    1443298668240
    1428458098640

    • shashish_jha's avatar
      shashish_jha
      New Contributor II
      3 years ago
      Copy LinkReport

      Date.parse($your_input_date).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”})
      You can change your desired formatting in this section : “format”:“yyyy-MM-dd HH:mm:ss”
      Place this expression into mapper snap and dynamically your_input_date will be picked up and formatted accordingly.

      • ykoppisetty's avatar
        ykoppisetty
        New Contributor II
        3 years ago
        Copy LinkReport

        Hi @j.angelevski @shashish.jha
        When I am trying through dynamically I am getting the below error.

        Can you please resolve this error. I have also tried the @shashish.jha formula. But that’s also getting error. Please help me on this.

        Thank you.