Forum Discussion

NAl's avatar
NAl
Contributor
12 months ago
Solved

Trim and convert string into Date

How can I trim the date on the left hand side and convert this into a date value?

Input Example: 18 May 2016 - 17 Mar 2017

Output example: 2016-05-18

(using the yyyy-MM-dd  format)

I've tried using trimLeft() function but the Mapper Snap doesn't recognise this expression (see screenshot attached).

  • Aleksandar_A's avatar
    Aleksandar_A
    12 months ago

    Hello NAl,

    Could you try with the following expression, and let me know if it works for you?

    Date.parse($Dates.split("-")[0].trim(),'dd MMM yyyy')

    Regards,

    Aleksandar.

5 Replies

  • Aleksandar_A's avatar
    Aleksandar_A
    Contributor III
    12 months ago

    Hello NAl,

    Could you try with the following expression, and let me know if it works for you?

    Date.parse($Dates.split("-")[0].trim(),'dd MMM yyyy')

    Regards,

    Aleksandar.

  • RogerSramkoski's avatar
    RogerSramkoski
    Employee
    12 months ago

    Hello NAl! A quick clarifying question, you want to take a string like "18 May 2016 - 17 Mar 2017", trim off the second date so you have "18 May 2016" then convert that to a date like "2016-05-18"? Or are you looking to convert both dates to the result would be "2016-05-18 - 2017-03-17"?

  • NAl's avatar
    NAl
    Contributor
    12 months ago

    So I have the expression which splits the date:

    $Dates.split(' - ')[0]

    which provides the result 18 May 2016.

    But the expression below for reformatting the date results in a NaN ouput:

    Date.parse($Dates.split(' - ')[0],"yyyy-mm-dd")