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

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

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