Difference between revisions of "Utilities Integration Bridge"
Jump to navigation
Jump to search
Line 42: | Line 42: | ||
[[File:Date_Formatter_Example.PNG|400px|right|<div align="center">'''Example iBridge Utility operation converting from the format "Y-m-d H:i:s" (e.g. 2019-01-03 06:43:21) to "d-m-Y" (e.g. 03-01-2019)'''</div>]] | [[File:Date_Formatter_Example.PNG|400px|right|<div align="center">'''Example iBridge Utility operation converting from the format "Y-m-d H:i:s" (e.g. 2019-01-03 06:43:21) to "d-m-Y" (e.g. 03-01-2019)'''</div>]] | ||
:: Lets you take the format of one date and convert it to another format. This is stored in a variable which can then be used in other BPM Operations. A common example is given in the image opposite but if you prefer a different format, the following reference will be useful: [https://www.php.net/manual/en/datetime.format.php '''Date Format Characters''']. This reference outlines the list of characters that can be used when defining your output format. | :: Lets you take the format of one date and convert it to another format. This is stored in a variable which can then be used in other BPM Operations. A common example is given in the image opposite but if you prefer a different format, the following reference will be useful: [https://www.php.net/manual/en/datetime.format.php '''Date Format Characters''']. This reference outlines the list of characters that can be used when defining your output format. | ||
+ | |||
+ | {{bullet1|Date|Most commonly, the variable picker will be used to get a date/time that is stored in a date/time field within Hornbill or it has been collected using Intelligent Capture.}} | ||
+ | {{bullet1|Input Format|Hornbill stores Date and Time in UTC format. This can be represented using "Y-m-d H:i:s"}} | ||
+ | {{bullet2|Y|A full numeric representation of a year, at least 4 digits (1999,2003, 2022)}} | ||
+ | {{bullet2|m|Numeric representation of a month, with leading zeros (01 through 12)}} | ||
+ | {{bullet2|d|Day of the month, 2 digits with leading zeros (01 to 31)}} | ||
+ | {{bullet2|H|24-hour format of an hour with leading zeros (00 through 23)}} | ||
+ | {{bullet2|i|Minutes with leading zeros (00 to 59)}} | ||
+ | {{bullet2|s|Seconds with leading zeros (00 through 59)}} | ||
+ | {{Bullet1|Output Format|}} | ||
|}} | |}} | ||
==Get Date Difference== | ==Get Date Difference== | ||
Returns the difference between two date/time stamps, in days, hours, minutes and seconds. In addition to this, it also provides a yes/no outcome for when the second time stamp is before the first time stamp. | Returns the difference between two date/time stamps, in days, hours, minutes and seconds. In addition to this, it also provides a yes/no outcome for when the second time stamp is before the first time stamp. | ||
+ | |||
==Get Day of Week== | ==Get Day of Week== |
Revision as of 01:20, 17 November 2022
Home > Integration > Business Process Automation & Orchestration > Hornbill iBridge > Utilities | Index |
Get Date Difference
Returns the difference between two date/time stamps, in days, hours, minutes and seconds. In addition to this, it also provides a yes/no outcome for when the second time stamp is before the first time stamp.
Get Day of Week
Hornbill Integration method for returning the day of the week for the specified timestamp
Get Next Date
- Lets you set a day of the week and the operation will return the date that this day falls on. This is stored in a variable which can then be used in other BPM Operation
Get Timestamp
- Lets you return a timestamp which is x days, hours, minutes before or after an existing timestamp. This is useful for generating a future date / time to use in other business process operations.
Password Generator
- A password generator tool to provide temporary passwords for users.
Read more about using the Integration Call from the Related Articles section, and learn how to work with input and output parameters for each of the Hornbill options.