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

Alteryx designer Discussions

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

Generate Rows - Start Date +1 from previous end date

Meteoroid

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! 

Alteryx Certified Partner

Hi,

 

In formula(7)

 

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

or

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

 

[]

Alteryx Certified Partner

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

Meteoroid

That works, thank you! 

Labels