MuleSoft DataWeave Date Time Formatting

Question

Using input payload of

{
"Date": "2025-09-09T18:03:06.830"
}

I'm trying to get an output of

"2025-09-09T18:03:06.830Z"

I've tried this DataWeave

%dw 2.0
output application/json
---
payload.Date as String {format: "yyyy-MM-dd'T'HH:mm:ss.SSSZ"}

But my output is coming back as

"2025-09-09T18:03:06.830"

Without the Z at the end of the milliseconds

I've also tried

%dw 2.0
output application/json
---
payload.Date as String {format: "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"}

With no luck

I can't seem to find as DateTime formatting that is helping me either. I've also found outputs with 2 milliseconds and a Z but not 3 (such as the basic payload.Date as DateTime output)

This question is similar to: Dataweave Date Formatting with Timezone. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — aled
– aled, Commented Sep 9 at 20:42

ndtorre · Accepted Answer · 2025-09-09 20:43:40Z

0

Interesting find, so if I use

(payload.Date as DateTime) as String {format: "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"}

I get the string that I'm looking for.

A couple of conversions, but it gets the job done.

answered Sep 9 at 20:43

ndtorre

313 bronze badges

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

1 Comment

aled Sep 10 at 12:02

They are not additional conversions. The date/time formatting only makes sense when converting from/to Date/Time types and String. String or Date/Times don't have formats in DataWeave, like Java. The input here is a String and the output is a String. You need to convert to a Date/Time type first to change the output format.

Collectives™ on Stack Overflow

MuleSoft DataWeave Date Time Formatting

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related