Data Manipulation using Date Formulas

SUMMARY: 🔔To use formulas in Workato, activate formula mode at the field level. 🔔Formula mode provides approved formulas and guidance for data manipulation. 🔔The editor shows type-specific formulas based on the data-pill type in an input field. 🔔Text must be explicitly formatted in formula mode, unlike in text mode. 📚 1. ago #Syntax Unit.ago Unit - A time value to offset. 📚 2. yday #Syntax Date.yday Date - A date or datetime datatype. 📚 3. strftime #Syntax Date.strftime(format) Date - An input date or datetime. format - The format of the user-defined datetime written as a string. 📚 4. to_date #Syntax String.to_date(format: format) String - An input datetime or a string that describes a date or datetime. format - (optional) The date format of the input written as a string. If not specified, Workato will parse the input string automatically. 📚 Previous Session Link: https://youtu.be/Q5BqJPj5tUw?si=6v3xg7B72sIMbttt Find #Workato everywhere! ► Website: www.workato.com ► Twitter: https://twitter.com/workato ► LinkedIn: https://www.linkedin.com/company/workato/ ► Instagram: https://www.instagram.com/workatohq/?... 🔔Got suggestions for topics? Leave your comment down below or drop us a note at [email protected]