This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Debating whether or not to upgrade to the latest version of Alteryx Designer?
- edited on
How to: Create a new date field based on a formula?
For example, let's say I want to calculate one month prior to an existing date. i.e. 6/1/15, month prior is 5/1/15.
To do this, I'll add a Formula tool to the canvas, connect it to your data stream, and use the DateTimeAdd() function.
DateTimeAdd([Date], -1, 'month')