16 Nov
Convert date and time value to specified time zone
The “World Time” action converts date and time values between two time zones.
Date and time conversions are a fundamental part of many applications, especially for organizations that have locations or customers across the country or around the globe. But they are hard to get right and often involve complex expressions and syntax that looks a lot like custom code.
The “World Time” action in PowerTools makes it easy to convert dates and times into any time zone. Simply provide a date and select a target time zone from anywhere on the globe. Done! You can even supply your own formatting string if you wish to get just the right output you are looking for.
Parameters
| Title | Name | Type | Description |
|---|---|---|---|
Value | input | date/time | Source date and time |
Source | source | string | Source time zone |
Target | target | string | Target time zone |
Format | format | string | Formatting string |
Response
Status | Title | Name | Type | Description |
|---|---|---|---|---|
Success | Result | result | string | Formatted date string |
Failure | Result | result | string | Error description |
- How to convert date and time value to specified time zone with Microsoft Power Automate
- How to convert date and time value to specified time zone with Microsoft Power Apps
- How to convert date and time value to specified time zone with Salesforce
- How to convert date and time value to specified time zone with Nintex
- How to convert date and time value to specified time zone with Custom API
How to convert date and time value to specified time zone with Microsoft Power Automate
Instructions
- In the Flow designer, click the “+” icon to insert a new action.
- Select the “DateTime – World Time” action under PowerTools in the “Choose an operation” dialog.
- Insert the necessary values or variables in each input field.
- Execute the flow.
Example
Video
How to convert date and time value to specified time zone with Microsoft Power Apps
Instructions
- Add the PowerTools connector from the Data menu.
- In the formula for the control, variable or element, type “ApptigentPowerTools.CountCollection().result”. Within the parentheses, enter the field, control or variable that contains the source collection.
- Preview or run the app.
Example
Coming Soon
Video
How to convert date and time value to specified time zone with Salesforce
Instructions
- Drag and drop a new action onto the design surface. Edit the action and choose PowerTools from the category menu on the left.
- Click in the “Action” search box, scroll through the action list and choose “DateTime – World Time”. Insert the necessary values or variables in each input field. (Note: Click the “Advanced” link to manually assign output variables to the action results)
- Run or Debug your flow to preview the results.
Example
Video
How to convert date and time value to specified time zone with Nintex
Instructions
- Locate the “Apptigent PowerTools” group in the actions navigator then drag and drop the “DateTime – World Time” action onto the design surface.
- Insert the necessary values or variables in each input field.
- Assign the result to a variable.
- Test the workflow.
Example
Video
How to convert date and time value to specified time zone with another Platform or Custom Code
Instructions
If your platform is not listed and it supports Open API (Swagger) extensions, import the API Definition document from the Developer Edition product on our Customer Portal at https://portal.apptigent.com/product (look for the Open API link at the top of the PowerTools Developer API definition page). Invoke the desired actions in your app or workflow design tool, supplying values for the listed parameters. Refer to the developer documentation on the Customer Portal for details on input and output formats.
If you are developing a custom app, execute a RESTful POST operation to the /CountCollection endpoint in your application code or use the pre-generated client scaffolding from our Github repo at https://github.com/apptigent/powertools. Be sure to include your API Key (Client ID) in the header using the “X-IBM-Client-Id” key/value pair. The body should be a well-formed JSON object with the parameter label(s) and value(s) in the specified format. Refer to the API documentation at https://portal.apptigent.com for more information.
Example
const request = require('request');
const options = {
method: 'POST',
url: 'https://connect.apptigent.com/api/utilities/WorldTime',
headers: {
'X-IBM-Client-Id': 'REPLACE_THIS_KEY',
'content-type': 'application/json',
accept: 'application/json'
},
body: {
input: '03/10/2010 09:00:00',
source: 'GMT Standard Time - (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London',
target: 'Central Standard Time - (GMT-06:00) Central Time (US & Canada)',
format: 'yyyy-MM-dd HH:mm:ss'
},
json: true
};
request(options, function (error, response, body) {
if (error) throw new Error(error);
console.log(body);
});
