Unable to coerce a :string to :datetime

Question

I am unable to use Mulesoft DataWeave to effectively transform a Date to a DateTime. For some reason, Mulesoft is treating the Date as a String.

What can I do to fix this issue and convert the date properly? The format I am attempting to go from is yyyy-mm-dd to mm/dd/yyyy hh:mm:ss.

Error:

Cannot coerce a :string to a :datetime, caused by :Text '2019-03-08' could not be parsed at index 2.

DataWeave

DateCustomFieldRef__custentity_icims_legacy_f_next_renewal: flowVars.SalesforceAccount.Contract_End_Date__c as :datetime {format: "dd/MM/yyyy HH:mm:ss"}

In the example above, flowVars.SalesforceAccount.Contract_End_Date__c is a DATE, and DateCustomFieldRef__custentity_icims_legacy_f_next_renewal is a Date_time in NetSuite.

AnupamBhusari · Accepted Answer · 2017-02-15 18:14:14Z

1

As per Mule Type Coercion Table :date to :date time Coercion not possible. You have to append time something like below to get expected result. As time will be default 00:00:00

%dw 1.0
%output application/java
---
("2017-02-15" ++ "00:00:00" )as :localdatetime  {format: "yyyy-MM-ddHH:mm:ss"} as :string {format: "dd/MM/yyyy HH:mm:ss"}

HTH

answered Feb 15, 2017 at 18:14

AnupamBhusari

2,4152 gold badges17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to coerce a :string to :datetime

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related