Generate List of Quarter End Given A Beginning and Ending Date

[hyan028]

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):

Thanks,

Blake

[jdunkerley79 · Accepted solution]

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]

This makes perfect sense!  Thank you!

Best,

Blake

[Thableaus]

Hi @hyan028

This is the solution I thought.

Cheers,

[hyan028]

Yeah, this works too!

Thank you,

Blake