Dates - Calc Using Formula

[suby]

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.

[atcodedog05 · Accepted solution]

Hi @suby 

Here is how you can do it.

Workflow:

1. Convert dates to alteryx dates.

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

Hope this helps : )

[dhavaldoshi · Accepted solution]

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.

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

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