We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Subtract 1 Day from the date value in the below row for each employee

Kavya132017
8 - Asteroid

Hey everyone,

 

I want to get 1 day minus of the value in next row for each employee.Attached the sample data..I need to derive "End Date" Column.

 

Thanks in advance!

1 REPLY 1
Christina_H
14 - Magnetar

Use a multi-row formula, grouped by employee ID.  DateTimeAdd([Row+1:Start Date],-1,"day")

Christina_H_0-1684248741717.png

 

Labels
Top Solution Authors