cancel
Showing results for 
Search instead for 
Did you mean: 

Trim and convert string into Date

NAl
Contributor

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).

1 ACCEPTED SOLUTION

Aleksandar_A
Contributor III

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.

View solution in original post

5 REPLIES 5

RogerSramkoski
Employee
Employee

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
Contributor

Hi @RogerSramkoski,

It'll be the first option so "2016-05-18"

NAl
Contributor

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")

 

Aleksandar_A
Contributor III

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.