Difference between revisions of "Utilities Integration Bridge"
Jump to navigation
Jump to search
Line 54: | Line 54: | ||
::::'''s''' - Seconds with leading zeros (00 through 59) | ::::'''s''' - Seconds with leading zeros (00 through 59) | ||
{{Bullet1|Output Format|Provide a format that you would like to convert the Date to using [https://www.php.net/manual/en/datetime.format.php '''Date Format Characters'''].}} | {{Bullet1|Output Format|Provide a format that you would like to convert the Date to using [https://www.php.net/manual/en/datetime.format.php '''Date Format Characters'''].}} | ||
− | |||
===Response Parameters=== | ===Response Parameters=== | ||
Line 62: | Line 61: | ||
::If you are getting a date from an external integration, the date format may be stored differently in that external app and you'll need to convert it to UTC format that's used in Hornbill. | ::If you are getting a date from an external integration, the date format may be stored differently in that external app and you'll need to convert it to UTC format that's used in Hornbill. | ||
::If you only require the part of the response, such as just the date (Y-m-d) or just the time (H:i:s) | ::If you only require the part of the response, such as just the date (Y-m-d) or just the time (H:i:s) | ||
+ | |}} | ||
+ | |||
{{TOP}} | {{TOP}} | ||
+ | |||
{{Section| | {{Section| | ||
==Get Date Difference== | ==Get Date Difference== | ||
Line 68: | Line 70: | ||
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. | ||
− | + | ===Request Parameters=== | |
{{bullet1|First DateTime|Type in the year, month, date, hours (24 hour), minutes, seconds to provide the first Date/Time. Or use the variable picker to select a date that is stored in Hornbill. }} | {{bullet1|First DateTime|Type in the year, month, date, hours (24 hour), minutes, seconds to provide the first Date/Time. Or use the variable picker to select a date that is stored in Hornbill. }} | ||
{{bullet1|Second DateTime|Type in the year, month, date, hours (24 hour), minutes, seconds to provide the second Date/Time. Or use the variable picker to select a date that is stored in Hornbill.}} | {{bullet1|Second DateTime|Type in the year, month, date, hours (24 hour), minutes, seconds to provide the second Date/Time. Or use the variable picker to select a date that is stored in Hornbill.}} | ||
− | This automations assumes that UTC date/time format is being used. If you have dates from an external app through integrations that are not UTC format, you can use the Date Formatter to convert them to UTC. | + | === Response Parameters=== |
+ | {{bullet1|Days|The total number of days between the two dates}} | ||
+ | {{bullet1|Hours|The total number of hours between the two dates}} | ||
+ | {{bullet1|Minutes|The total number of minutes between the two dates}} | ||
+ | {{bullet1|Second Timestamp before First Timestamp|Returns ''yes'' if true, and ''no'' if false}} | ||
+ | {{bullet1|Seconds|The total number of seconds between the two dates}} | ||
+ | {{infobox|This automations assumes that UTC date/time format is being used. If you have dates from an external app through integrations that are not UTC format, you can use the Date Formatter to convert them to UTC.}} | ||
|}} | |}} | ||
{{TOP}} | {{TOP}} |