Date

You can perform operations to compare, format, and manipulate date and time values.

Calculate Date Difference

You can calculate the difference between two given dates.

The input fields are as follows;

Start Date Pattern: Date format associated with the start date.

Start Date: Start date from which you want to start calculating the difference.

End Date Pattern: Date format associated with the end date.

End Date: The date up to which you want to calculate the difference.

Example - If the Start Date Pattern is YYYY-MM-DD, the Start Date is 2019-06-05, the End Date Pattern is YYYY-MM-DD, and the End Date is 2019-07-05, the Calculate Date Difference operation returns the following values:

dateDifferenceSeconds - 2,590,000
dateDifferenceMinutes - 43,200
dateDifferenceHours - 720
dateDifferenceDays - 30
dateDifferenceMonths - 1
dateDifferenceYears - 0

Compare Dates

You can compare dates to check whether they are the same or not.

The input fields are as follows:

Start Date Pattern: Date format associated with the start date.

Start Date: Start date from you want to compare.

End Date Pattern: Date format associated with the end date.

End Date: End date you want to compare.

Example - If you specify 2019-06-05 as the Start Date and 2019-07-05 as the End Date, the Compare Dates operation returns -1. If you specify 2019-06-05 as the Start Date and 2019-06-05 as the End Date, the Compare Dates operation returns 0.

Current Milliseconds

You can fetch the number of milliseconds for the current time.

No input fields.

Date Build

You can create a date in the specified format.

The input fields are as follows:

Year: Enter the year for the date you want to create in the YYYY format. It must be less than or equal to 9999.

Month: Enter the month for the date you want to create in the MM format. It must be less than or equal to 12.

Day: Enter the year for the date you want to create in the DD format.

Date Pattern: Specify the date format for the specified date.

Locale: Specify the locale for the date.

Time zone: Specify the time zone for the date. The default time zone is GMT.

Example - If you specify the Year as 2019, the Month as 07, and the Day as 24, the Date Build operation returns 2019-05-24T00:00:00Z.

Date Time Build

You can create a date (along with time) in the specified format.

The input fields are as follows:

Year: Enter the year for the date you want to create in the YYYY format. It must be less than or equal to 9999.

Month: Enter the month for the date you want to create in the MM format. It must be less than or equal to 12.

Day: Enter the year for the date you want to create in the DD format.

Hour: Enter the hour for the time you want to create in the HH format. It must be less than or equal to 24.

Minute: Enter the minute for the time you want to create in the MM format. It must be less than or equal to 60.

Second: Enter the second for the time you want to create in the SS format. It must be less than or equal to 60.

Millisecond: Enter the millisecond for the time you want to create in the SSS format. It must be less than or equal to 999.

Date Pattern: Specify the date format for the specified date.

Locale: Specify the locale for the date.

Time zone: Specify the time zone for the date. The default time zone is GMT.

Example - If you specify the Year as 2019, Month as 07, and Day as 24, Hour as 09, Minute as 45, Second 55, Millisecond as 34, the Date Time Build operation returns 2019-07-24T09:45:55Z.

Date Time Format

You can change the format of a date.

The input fields are as follows: Input Fields

Date: Specify the date of which format you want to change.

Provided Date Pattern: Specify the date format for the specified date.

Locale: Specify the locale for the date.

New Pattern: Specify the date pattern that you want to convert the date to.

Example - If you specify the date as 2019-07-08 and the New Pattern as YY-MM-DD, then the Date Time Format operation returns 19-07-08.

Elapsed Milliseconds

You can retrieve the number of milliseconds elapsed since a specified time (in milliseconds).

The input field is as follows:

Milliseconds: The time (in milliseconds) from which you want to calculate the elapsed milliseconds.

Example - If the Milliseconds value is 999999, the Elapsed Milliseconds operation returns 1562563942577 in Milliseconds, 1562563942 in Seconds, 26042732 in Minutes, 434045 in Hours, 18085 in Days, 594 in Months, and 49 in Years.

Get Current Date String

You can fetch the current date in the specified format.

The input fields are as follows: Input Fields

Pattern: Specify the format in which you want to fetch the current date.

Locale: Specify the locale for the date.

Time zone: Specify the time zone for the date.

Example - If the current date is 8 July 2019, and you specify YYYY-MM-DD as the pattern, the Get Current Date String operation output will return 2019-07-08.

Increment Date

You can add the time to the specified date.

The input fields are as follows:

Start Date: Specify the date to which you want to add time.

Pattern: Specify the pattern for the specified date.

Add Years: Number of years that you want to add to the specified date.

Month: Number of months you want to add to the specified date.

Day: Number of days you want to add to the specified date.

Hour: Number of hours you want to add to the specified date.

Minute: Number of minutes you want to add to the specified date.

Second: Number of seconds you want to add to the specified date.

Millisecond: Number of milliseconds you want to add to the specified date.

Locale: Specify the locale for the date.

Time zone: Specify the time zone for the date.

Example - If you specify the Start Date as 2019-07-08, Pattern as YYYY-MM-DD, Add Years as 2, add Months as 4, add Days as 30, add Hours as 10, add Minutes as 40, and add Seconds as 50, the Increment Date operation output will return 2021-12-08T10:40:50.000+00:00.

Convert date to ISO format

You can convert the specified date to the ISO format.

The input fields are as follows:

Date: Specify the date that you want to convert to ISO format.

Pattern: The pattern for the specified date.

Locale: Specify the locale for the date.

Time zone: Specify the time zone for the date.

Example - If you specify the Date as 2019-07-08, the Convert date to ISO will return 2019-07-08T00:00:00Z.