Alteryx Designer Desktop Discussions

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

Generate Rows - Start Date +1 from previous end date

mhart
7 - Meteor

Hello,

 

I am generating multiple rows in 15-day increments for the past 6 months. I'm trying to make it where the start day is 1 day after the previous end date (i.e., no start/end date should equal each other). See attached for my current workflow. Thanks for your help in advance! 

3 REPLIES 3
geraldo
13 - Pulsar

Hi,

 

In formula(7)

 

DateTimeAdd(DateTimeAdd([PeriodStart],-1,"days"),15,"days")

or

DateTimeAdd(DateTimeAdd([PeriodStart],+1,"days"),15,"days")

 

[]

JosephSerpis
17 - Castor
17 - Castor

Hi @mhart think I produced the results you described. Let me know what you think? 

mhart
7 - Meteor

That works, thank you! 

Labels