Forum Discussion

NAl's avatar
NAl
Contributor
2 years 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 usi...
  • Aleksandar_A's avatar
    Aleksandar_A
    2 years 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
2 years 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"?