Forum Discussion

RoyB's avatar
RoyB
New Contributor III
5 years ago

DateTime Parameter can't save to datetime field

I’m calling a child pipeline to do an insert I’m passing a datetime field, but in the child parameter it is now a string How do I convert it back to datetime? In the parent before I execute the...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
5 years ago
Copy LinkReport

@RoyB

You can try with the following expression in the child pipe:

Date.parse(JSON.parse(_StartDate))

Or to avoid sending the string {“_snaptype_localdatetime”:“1996-08-26T00:00:00.000”} to the child pipeline, from the parent pipeline try to send the date field(StartDate) as a string(not as a datetime), and then try to convert to date with Date.parse(_StartDate).

Regards,
Spiro Taleski

  • RoyB's avatar
    RoyB
    New Contributor III
    5 years ago
    Copy LinkReport

    I’ve tried both of those, and each time it errors as not a number error

    We managed to build a work around though, buy setting up some snaps to except the values as part of the incoming document rather than passing a parameter

    Thanks for the help