Date and time transform functions

Date and time transform functions require a Date/Time or String input data pill. Some functions also support Duration data pills. Make sure to use the correct input data pill type when applying date and time transform functions. If a date and time transform function is applied to an improper data pill type, the data is not transformed at runtime and the input value is returned instead. For more information on confirming your flow runtime values, see Test a flow.

Note: Runtime Date/Time values are not localized and appear in the UTC (Coordinated Universal Time) time zone. For more information, see Time zones and time zone representation.

Add Time

Adds days, hours, minutes, or seconds to an input Date/Time, Date, Due Date, or Duration.


Input data pill	Parameters	Output data pill
Date/Time, Date, Due Date, or Duration Note: If the input is a Date or Due Date, the transform creates a full Date/Time value using time values of hour 0, minute 0, and second 0.	Duration - Amount of time to add in days, hours, minutes, and seconds	Date/Time - Transformed Date/Time value after adding the specified Duration

Figure 1. Example

Input: 2019-09-12 11:00:00
Duration: 3 hours
Output: 2019-09-12 14:00:00

Subtract Time

Subtracts days, hours, minutes, and/or seconds from the input Date/Time, Date, Due Date, or Duration.


Input data pill	Parameters	Output data pill
Date/Time, Date, Due Date, or Duration Note: If the input is a Date or Due Date, the transform creates a full Date/Time value using time values of hour 0, minute 0, and second 0.	Duration - Enter an amount of time to subtract in days, hours, minutes, and seconds	Date/Time - Transformed Date/Time value after subtracting the specified Duration

Figure 2. Example

Input: 2019-09-12 11:00:00
Duration: 2 days, 1 hours, 5 minutes, 10 seconds
Output: 2019-09-10 09:54:50

In this example, the flow retrieves a CMDB Configuration Item record from a remote instance. The Subtract Time transform function then localizes the value of the Created field by subtracting three hours from the input Date/Time.

Localize a field value's time zone. — Figure 3. Localize a field value's time zone

String to Date

Converts the input String to a Date/Time.


Input data pill	Parameters	Output data pill
String formatted as specified in the Input Date Format	Input Date Format - Date/Time or date format of the input String Custom Format - Valid Date/Time or date format represented as a String. Required only if Custom Format is selected as the Input Date Format.	Date/Time

Note:

If the Date/Time value for the Custom Format input is incomplete, the transform creates a full Date/Time value using default dates and times. In such a case, the transform defaults to the current year, the current month, day 1 of a month, hour 0, minute 0, and second 0. For example, an input data pill value of Oct 2019 and a custom date format of MMM yyyy produces an output of 2019-10-01 00:00:00.
If you use an incorrect data pill type or invalid Custom Format, the flow cancels during runtime.

Figure 4. Example

Input: '1995-11-20'
Input Date Format: ISO Date (2004-06-28)
Output: 1995-11-20 00:00:00

Date to String

Converts the input Date/Time, Date, or Due Date to a String. Select a Date Format for the input Date/Time. Alternatively, enter a Custom Format for the input Date/Time.


Input data pill	Parameters	Output data pill
Date/Time, Date, or Due Date	Output Date Format - Date/Time or date format of the output String Custom Format - Valid Date/Time or date format represented as a String. Required only if selecting Custom Format as the Date Format.	String formatted as specified in the Output Date Format

Note: If you use an incorrect input data pill type or invalid Custom Format, the flow cancels during runtime.

Concatenate a Date/Time value with a String value. — Figure 5. Example

Custom date formats

You can specify a custom date format with a sequence of specific date and time pattern strings. A pattern string consists of one or more uppercase and lowercase letters from A to Z. Any text within quotation marks is ignored and is instead copied into the date output.

Search:


String	Description	Output Format	Example
G	Era designator	Text	AD
y	Year	Year	2019; 19
Y	Week in year	Year	2019; 19
M	Month in year (within date)	Month	July; Jul; 07
L	Month in year (standalone value)	Month	July; Jul; 07
w	Week in year	Number	52
W	Week in month	Number	1
D	Day in year	Number	365
d	Day in month	Number	2
F	Day of week in month	Number	3
E	Day name in week	Text	Wednesday; Wed
u	Day number of week	Number	3
a	a.m. or p.m.	Text	p.m.
H	Hour in day from 0 through 23	Number	0
k	Hour in day from 1 through 24	Number	24
K	Hour in a.m. or p.m. from 0 through 11	Number	0
h	Hour in a.m. or p.m. from 1 through 12	Number	12
m	Minute in hour	Number	59
s	Second in minute	Number	1
S	Millisecond	Number	500
z	Time zone in default format	Time zone in default format	Pacific Standard Time; PST
Z	Time zone in RFC 822 format	Time zone in RFC 822 format	-0800
X	Time zone in ISO 8601 format	Time zone in ISO 8601 format	-08; -0800; -08:00

Day

Retrieves the day component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Day from the specified date.

Figure 7. Example

Input: 2021-11-20 13:06:12
Input Date Format: ISO Date (2004-06-28)
Output: 20

Hour

Retrieves the hour component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Hour from the specified date.

Figure 8. Example

Input: 2021-11-20 13:06:12
Input Date Format: ISO Date (2004-06-28)
Output:13

Minute

Retrieves the minute component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Minute component from the specified date.

Figure 9. Example

Input: 2021-11-20 13:06:12
Input Date Format: ISO Date (2004-06-28)
Output: 06

Second

Retrieves the second component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Second component from the specified date.

Figure 10. Example

Input: 2021-11-20 13:06:12
Input Date Format: ISO Date (2004-06-28)
Output: 12

Month

Retrieves the month component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Month component from the specified date.

Figure 11. Example

Input: 2021-11-20 13:06:12
Input Date Format: ISO Date (2004-06-28)
Output: 11

Week

Evaluates the week number for the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Week number for the specified date.

Figure 12. Example

Input: 2021-04-07 12:01:12
Input Date Format: ISO Date (2004-06-28)
Output: 15

Year

Retrieves the year component from the specified Date/Time.


Input data pill	Output data pill
Date/Time	Integer - Year component from the specified date.

Figure 13. Example

Input: 2021-04-07 12:01:12
Input Date Format: ISO Date (2004-06-28)
Output: 2021

Date Difference

Evaluates the time duration difference between the specified input date and the parameter date and then adds the difference time duration to the Epoch time (1970-01-01 00:00:00).


Input data pill	Parameters	Output data pill
Date/Time, Date, or Due Date	Date/Time, Date, or Due Date	Duration - Time duration difference added to the Epoch time (1970-01-01 00:00:00).

Figure 14. Example

Input: 2021-05-02 09:10:12
Input Date Format: ISO Date (2004-06-28)
Parameters: 2021-04-07 06:02:23
Output: 1970-01-26 03:07:49

End of Month

Evaluates the last day of the month after adding the specified number of the months to the specified date.


Input data pill	Parameters	Output data pill
Date	Number of Months - Months to add to the specified date.	Integer - Last day of the month after adding the number of months to the specified input date.

Figure 15. Example

Input: 2021-11-20
Input Date Format: ISO Date (2004-06-28)
Number of Months: 3
Output: 2022-02-28

Yokohama Build workflows

Filters

Versions

Products