Introduction
A Utility for date format conversions and a password generator have been provided as part of the Cloud Automations that can be used within a BMP or AutoTask workflow.
Within the workflow designer, when adding a new node, select the option for Cloud Automation. No authentication or licensing is required to access and use these utilities.
Adding a Utility to a Workflow
- Add a Cloud Automation node to your workflow
- Access the properties of that node
- On the Method field, select edit button to view the available integrations
- Find Utilities within the list
- Expand and select the automation that you wish to use.
Current Day
Retrieves the current day of the week and stores it in a variable which can be used in other BPM 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.
-
- &[global["UtilitiesCurrentDay"]["day"]]
-
- Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday
Example Use:
- Prior to a Service Manager Request Assignment node, you may want to check the day of the week. If it is a Saturday or Sunday you could take the decision to assign to a team that covers weekends.
(Top of Page)
Date Formatter
- 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: Date Format Characters. This reference outlines the list of characters that can be used when defining your output format.
-
- 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.
-
- Hornbill stores Date and Time in UTC format. This can be represented using "Y-m-d H:i:s"
- 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)
- d - Day of the month, 2 digits with leading zeros (01 to 31)
-
- 24-hour format of an hour with leading zeros (00 through 23)
-
- Minutes with leading zeros (00 to 59)
-
- Seconds with leading zeros (00 through 59)
-
- Provide a format that you would like to convert the Date to using Date Format Characters. For example, if you only required the date and not the time you would have Y-m-d
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.
