• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Solutions Articles
  • Forums/Discussions
  • Submitted Tickets
× Frequently Asked Questions Getting Started Account related Billing

Recipe 101 Recipe Basics Building and Modifying Recipes Formula Mode Tips and Tricks Common Use Cases General Best Practices Recipe FAQs

App Resources Amazon S3 Box Callable Recipes Concur Dropbox Eventbrite Evernote Gmail Google Sheets Google Calendar HTTP Infusionsoft Intacct Intercom JIRA LinkedIn Mail Marketo Microsoft Dynamics CRM Netsuite People Task Quickbase QuickBooks Desktop QuickBooks Online RingCentral Salesforce Scheduler (Previously: Clock) ServiceNow Shopify SurveyMonkey SQL Server Utilities Workbot for Slack Watson Tone Analyzer Workday Xero Zendesk

Partners & Developers Developer Partner Resources



Troubleshooting Troubleshooting Basics Generic Errors Non-error Issues Concur Eventbrite Google Sheets Google Calendar Infusionsoft JIRA Mailchimp QuickBase QuickBooks Online Raiser's Edge NXT Replicon Salesforce ServiceNow Shopify Xero Workbot for Slack Zendesk





Formula Mode Tips & Tricks Date/Time Formulas Arithmetic Formulas Text Manipulation Formulas

☰ Categories
  • How do I get the date of the beginning/end of the current/next month?
    Thu, Aug 29, 2019 at 6:05 AM - Beginning of Current Month Firstly, turn on formula mode and we have access to the beginning_of_month function. It returns the date for the start of the month for the given date/timestamp. Beginning of Next Month To retrieve a date for the beginning of the next month, we simply need to a...
  • How do I add or subtract days or months from dates?
    Thu, Aug 29, 2019 at 5:59 AM - Adding and Subtracting Dates: You can add or subtract months, days, hours minutes or seconds from dates. Some scenarios might be: When creating an invoice in Xero, we wish to set the due date of the invoice to 30 days after the invoice has been sent When creating an opportunity in Salesf...
  • Date formatting: to_date versus strftime
    Thu, Aug 29, 2019 at 5:47 AM - There are 2 datetime formatting functions supported in formula mode that look similar. When should you be using which function? to_date Input: Date/time or String  Output: Date/time  Use to_date when you need to specify the input data's format. For example, if I'm ...

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