• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home Recipe 101 Building and Modifying Recipes

Building Recipes: Understanding and working with time zones in Workato

Modified on: Thu, Apr 27, 2017 at 2:23 PM

Time zone difference between applications could cause confusion and error in date/time or date entries. Hence, it is important to understand how Workato handles data that contains time zone elements. 



Data/time field with time zone element

Image 1


The time zone element refers to the time offset in a date/time pill that is passed from the source application. 


In Image 1, output of a newly created event in Google Calendar contains start and end date/time pill in the ISO8601 format (International Standard for the exchange of Time and Date data). The "-10:00" is the time offset with respect to UTC (Coordinated Universal Time). Hence the event is scheduled to start on 2017-04-03 at 12:00:51 Honolulu time (UTC -10:00). There is another common way of displaying date/time in applications. For example: "Mon, 10 Apr 2017 22:42:18 EST" means 10:42pm in Eastern Time. 


To check if the date/time pill you are passing in contains the time zone element, you could view the output example in the schema body on the right. 


Data/time field without time zone element


If a date/time field passed from the source application does not contain any time offset and the target application expects a timezone element, Workato will automatically pass in your Workato default timezone setting. It can be found in the user profile > Settings > Public profile > time zone



To manually add or change the time zone in a date or date/time pill, you can do so in formula mode. Refer to this article for basic date/time formatting

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2020   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato