Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Generate List of Quarter End Given A Beginning and Ending Date

hyan028
7 - Meteor

Hi,

 

I am thinking that I can use the multi-row formula to generate a list of quarter end based on a beginning and ending date.

 

So let's say the beginning date is 8/6/2014, and the ending date is 12/31/2019.  How to configure the multi row formula (or any other formula) to get a list like below (assume it is possible):

 

Capture.PNG

 

Thanks,

 

Blake

4 REPLIES 4
jdunkerley79
ACE Emeritus
ACE Emeritus

Do-able with a generate rows tool. The only complexity is the step function.

DateTimeAdd(DateTimeAdd(
    IF [Start] = [Accrual Period] THEN
        Left([Start],5) + 
        PadLeft(ToString(Ceil(DateTimeMonth([Start])/3)*3), 2, "0") + 
        "-01"
    ELSE
	DateTimeAdd(Left([Accrual Period], 8) + "01", 3, "months")       
    ENDIF
,1,"months"),-1,"days")

This will add the start point and then step in quarters.

Please note if the [end] is not an end of a quarter it will under-shoot. The iteration expression seemed complicated enough already so if not needed would live with this defect.

 

Sample attached

hyan028
7 - Meteor

This makes perfect sense!  Thank you!

 

Best,

 

Blake

Thableaus
17 - Castor
17 - Castor

Hi @hyan028

 

This is the solution I thought.

 

WF_Generate.PNG

 

Cheers,

hyan028
7 - Meteor

Yeah, this works too!

 

Thank you,

 

Blake

Labels