Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Generate Rows - Start Date +1 from previous end date

Highlighted
6 - 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! 

Highlighted
Alteryx Certified Partner

Hi,

 

In formula(7)

 

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

or

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

 

[]

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
6 - Meteoroid

That works, thank you! 

Labels