Manipulate Date Time Operations In Dataweave

This tutorial talks about how to manipulate different Date time operations in Dataweave, it include various Dataweave date time functions to perform date time conversions in different formats.

After this tutorial you will be able to perform different date time operations

Convert Current Datetime to CST Timezone

Dateweave Expression:

%dw 2.0
output application/java
---
now() as DateTime >> 'America/Chicago'

Result:

2020-07-19T09:56:14.020-05:00[America/Chicago]

Convert Current DateTime to specific string format(yyyy-MM-dd)

Dateweave Expression:

%dw 2.0
output application/java
---
now() as DateTime as String {format: "yyyy-MM-dd"}

Result:

2020-07-19

Convert Current DateTime to specific string format(yyyy-MMM-dd)

Dateweave Expression:

%dw 2.0
output application/java
---
now() as DateTime as String {format: "yyyy-MMM-dd"}

Result:

2020-Jul-19

Convert Current DateTime to specific string format( AM/PM)

Dateweave Expression:

%dw 2.0
output application/java
---
now() as DateTime as String {format : "d-MM-yyyy h:mm:ss a"}

Result:

19-07-2020 9:02:48 PM

Fetch Current Date In dataweave

Dateweave Expression:

%dw 2.0
output application/java
---
now() as Date

Result:

19-07-2020

Fetch Current Time In dataweave

Dateweave Expression:

%dw 2.0
output application/java
---
now() as Time

Result:

20:41:12.170+05:30

Format Time In dataweave(HH:MM:SS)

Dateweave Expression:

%dw 2.0
output application/java
---
now() as String {format: "hh:m:s"}

Result:

08:46:28

Fetch Year From Current Date in dataweave

Dateweave Expression:

%dw 2.0
output application/java
---
now().year

Result:

2020

Fetch current day value from current Date in dateweave

Dateweave Expression:

%dw 2.0
output application/java
---
now().day

Result:

19

Fetch month value from Current Date in dataweave

Dateweave Expression:

%dw 2.0
output application/java
---
now().month

Result:

7

Add,Substract Date and Time in dataweave

In this part we will see few examples where we will add and substract the day and time and use P as period date type

Get 2 Day prior Date

Dataweave Expression:

%dw 2.0
output application/java
---
now() - |P2D|

Result:

2020-07-20T13:27:16.731+05:30[Asia/Calcutta]

Get 2 Day prior Date from Custom Date Format

Dataweave Expression:

%dw 2.0
output application/java
---
"2020-02-01" - |P2D|

Result:

2020-01-30

Add No of Days to Current Date

Dataweave Expression:

%dw 2.0
output application/java
---
now() + |P2D|

Result:

2020-07-24T13:34:23.548+05:30[Asia/Calcutta]

Add No of Days to Custom Date

Dataweave Expression:

%dw 2.0
output application/java
---
"2020-02-01" + |P2D|

Result:

2020-02-03

Add No of Years to Current Date

Dataweave Expression:

%dw 2.0
output application/java
---
now() + |P2Y|

Result:

2022-07-22T13:36:45.855+05:30[Asia/Calcutta]

Add No of Years to Custom Formatted Date

Dataweave Expression:

%dw 2.0
output application/java
---
"2020-02-01" + |P2Y|

Result:

2022-02-01

Substract No of Years From Current Date

Dataweave Expression:

%dw 2.0
output application/java
---
now() - |P10Y|

Result:

2010-07-22T13:39:52.551+05:30[Asia/Calcutta]

Add Hours,Minute,Time In Current Time: we are adding 2 Hours,13 Minute and 9 Seconds, you can also substart the same using – symbol

Dataweave Expression:

%dw 2.0
output application/java
---
now() as String {format: "hh:m:s"} + |PT2H13M9S|

Result:

03:59:03Z

How to substract specific year with specific date and time from single dataweave expression

Dataweave Expression:

%dw 2.0
output application/java
---
|2020-11-02T23:57:59| - |P2Y9M1D| - |PT50M510S| + |PT3H|

Result:

2018-02-02T01:59:29

Compare 2 Dates In Dataweave

Dataweave Expression:

%dw 2.0
output application/java
---
now() as DateTime as String {format: "yyyy-MM-dd"} < "2020-09-10"

Result:

True

Dataweave Expression:

%dw 2.0
output application/java
---
now() as DateTime as String {format: "yyyy-MM-dd"} < "2020-09-10"

Result:

false