Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dates - Calc Using Formula

suby
9 - Comet

Hi ,

 

I'm trying to find the Difference in start dates and end dates and create a new column and thenhe flag based on two conditions.

 

-Greater than 12 and less than 15

-Greater than 15

 

Attached the sample workflow.

2 REPLIES 2
atcodedog05
20 - Arcturus

Hi @suby 

 

Here is how you can do it.

 

Workflow:

atcodedog05_0-1626427762274.png

 

1. Convert dates to alteryx dates.

2. Find diff between end and start dates to flag accordingly.

 

Hope this helps : )

 

dhavaldoshi
8 - Asteroid

DateFormat and Filter

Alteryx's default date format requirement is yyyy-mm-dd, if your input is of a different format and you want to perform date operations, you will have to use the date time parse tool first.

 

dhavaldoshi_1-1626427927559.png

 

 

 

Once you have formatted both the fields, use a formula tool

dhavaldoshi_2-1626427947828.png

 

 

So Formula -> For creating new fields or updating existing ones

Labels