×
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
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 strftimeThu, 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.