community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

How To: Create a new date field based on a Formula

Alteryx
Alteryx
Created 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.

 

Expression:

 

DateTimeAdd([Date], -1, 'month')

 2019-04-22_12-18-47.png

 

Attachments