Converting to a date format in Mule using DataWeave

Question

My requirement is to convert a string to a date format using DataWeave in Mule

Input string

8/30/2015  4:00:13 PM

Output date needs to be in MM/DD/YYYY format i.e,

08/30/2015

i have tried using the below logic

(($[1] splitBy " ")[0]) as :date{format:"[m01]/[d01]/[y0001]"}

this gave the error

Exception while executing: 
"Order Date":(($[1] splitBy " ")[0]) as :date{format:"[m01]/[d01]/[y0001]"},
 Cannot coerce a :string to a :date                                                                                                                                                          ^

I am using Mule Anypoint Studio Version: 5.2.0

Shoki · Answer 1 · 2019-11-15T16:23:11.537

First you need to convert it to a localdatetime (no timezone) and then to a string with the desired format.

"8/30/2015 4:00:13 PM" 
    as :localdatetime {format: "M/dd/yyyy h:mm:ss a"}
    as :string {format: "MM/dd/yyyy"}

In DataWeave 2.0 in Mule 4 it should be

"8/30/2015 4:00:13 PM" 
    as LocalDateTime {format: "M/dd/yyyy h:mm:ss a"}
    as String {format: "MM/dd/yyyy"}

For additional info see. https://docs.oracle.com/javase/8/docs/api/java/time/format/DateTimeFormatter.html

All letters 'A' to 'Z' and 'a' to 'z' are reserved as pattern letters. The following pattern letters are defined:

  Symbol  Meaning                     Presentation      Examples
  ------  -------                     ------------      -------
   G       era                         text              AD; Anno Domini; A
   u       year                        year              2004; 04
   y       year-of-era                 year              2004; 04
   D       day-of-year                 number            189
   M/L     month-of-year               number/text       7; 07; Jul; July; J
   d       day-of-month                number            10

   Q/q     quarter-of-year             number/text       3; 03; Q3; 3rd quarter
   Y       week-based-year             year              1996; 96
   w       week-of-week-based-year     number            27
   W       week-of-month               number            4
   E       day-of-week                 text              Tue; Tuesday; T
   e/c     localized day-of-week       number/text       2; 02; Tue; Tuesday; T
   F       week-of-month               number            3

   a       am-pm-of-day                text              PM
   h       clock-hour-of-am-pm (1-12)  number            12
   K       hour-of-am-pm (0-11)        number            0
   k       clock-hour-of-am-pm (1-24)  number            0

   H       hour-of-day (0-23)          number            0
   m       minute-of-hour              number            30
   s       second-of-minute            number            55
   S       fraction-of-second          fraction          978
   A       milli-of-day                number            1234
   n       nano-of-second              number            987654321
   N       nano-of-day                 number            1234000000

   V       time-zone ID                zone-id           America/Los_Angeles; Z; -08:30
   z       time-zone name              zone-name         Pacific Standard Time; PST
   O       localized zone-offset       offset-O          GMT+8; GMT+08:00; UTC-08:00;
   X       zone-offset 'Z' for zero    offset-X          Z; -08; -0830; -08:30; -083015; -08:30:15;
   x       zone-offset                 offset-x          +0000; -08; -0830; -08:30; -083015; -08:30:15;
   Z       zone-offset                 offset-Z          +0000; -0800; -08:00;

   p       pad next                    pad modifier      1

   '       escape for text             delimiter
   ''      single quote                literal           '
   [       optional section start
   ]       optional section end
   #       reserved for future use
   {       reserved for future use
   }       reserved for future use

score 2 · Answer 2 · answered Oct 13 '15 at 12:04

In DataWeave, you can parse a string to various Java datetime types as well as format them back to strings. Try a parse followed by a format, like so:

payload.date as :localdatetime {format: "M/dd/yyyy  h:mm:ss a"} as :string {format: "MM/dd/yyyy"}

Here's some more detail on date formatting in DataWeave.

score 1 · Answer 3 · answered Oct 25 '15 at 10:22

1

Hi in dataweave you can write expression like this

formatedDate: |2003-10-01T23:57:59| as :string {format: "MM-dd-YYYY"}

answered Oct 25 '15 at 10:22

Utsav

1,593
4
22
46

score -5 · Answer 4 · edited May 23 '17 at 12:17

-5

You can use this,

var newDate = new Date("8/30/2015  4:00:13 PM");
var dd = newDate.getDate();
var mm = newDate.getMonth()+1; //January is 0!

var yyyy = newDate.getFullYear();
if(dd<10){
    dd='0'+dd
} 
if(mm<10){
    mm='0'+mm
} 
var formattedDate = mm+'/'+dd+'/'+yyyy;
console.log(formattedDate);  //Prints "08/30/2015"

Please refer this

edited May 23 '17 at 12:17

Community

1
1

answered Oct 12 '15 at 07:37

nim007

2,958
3
16
28

This is a java script whereas my requirement is to use Mule functions or Mule expression Language. Thanks anyways – keerthi ch Oct 12 '15 at 08:31

Converting to a date format in Mule using DataWeave

4 Answers4

Linked