Difference between revisions of "Utilities Integration Bridge"
Jump to navigation
Jump to search
Line 25: | Line 25: | ||
{{Section| | {{Section| | ||
==Current Day== | ==Current Day== | ||
− | [[file:currentdayCA.png|right|400px]]Retrieves the current day of the week and stores it in a variable which can be used in other | + | [[file:currentdayCA.png|right|400px]]Retrieves the current day of the week and stores it in a variable which can be used in other Hornbill Automations or decision nodes. |
There are no parameters to configure with the node. Simply added where needed and then use the Output Parameter with decision nodes or to update a record with the day. | There are no parameters to configure with the node. Simply added where needed and then use the Output Parameter with decision nodes or to update a record with the day. | ||
Line 41: | Line 41: | ||
==Date Formatter== | ==Date Formatter== | ||
[[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 | + | :: 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 Hornbill Automations. See [https://www.php.net/manual/en/datetime.format.php '''Date Format Characters''']to get a list of characters that can be used when defining your input and output formats. |
{{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|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"}} | + | {{bullet1|Input Format|Hornbill stores Date and Time in UTC format. This can be represented using "Y-m-d H:i:s". If you are getting a date from an external integration, the date format may be stored differently in that app and you'll need to see documentation on that app to determine the date/time format.}} |
::::'''Y''' - A full numeric representation of a year, at least 4 digits (1999,2003, 2022) | ::::'''Y''' - A full numeric representation of a year, at least 4 digits (1999,2003, 2022) | ||
::::'''m''' - Numeric representation of a month, with leading zeros (01 through 12) | ::::'''m''' - Numeric representation of a month, with leading zeros (01 through 12) |
Revision as of 01:43, 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.