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 Anniversary Dates using generate row tool

Uthpala_K
6 - Meteoroid

Hi Team,

 

Continuation of a question I asked a couple of weeks back (that was solved successfully):

 

I am trying to calculate each occurrence of an anniversary date between a start and an end date that has an bi-annual anniversary date.

Previously I was having annual anniversary dates and was using the field 'Frequency' to update the tool using the frequency of 'year'.

Now, I am unsure how to configure the formula in the generate row tool to input half-yearly dates.

 

e.g. 1

Licence Start Date - 2017-07-04

Licence End Date - 2030-07-04

Bi-annual Anniversary Dates - 01-Jan & 01-Jul (i.e. first half-yearly anniversary for this item will be on 2018-01-01)

 

 
 

Alteryx.jpg

 

Thank you

Uthpala

 

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@Uthpala_K 
Hope this what you need. If you like it, appreciate if you would mark it as accepted.1016-Uthpla_K.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @Uthpala_K 

 

Here is a workflow for the task.

Input:

atcodedog05_0-1602826592411.png

Output:

atcodedog05_1-1602826612227.png

Workflow:

atcodedog05_2-1602826629631.png

Generate row tool config:

atcodedog05_3-1602826671290.png

Hope this helps 🙂


If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Uthpala_K
6 - Meteoroid

@Qiu Perfect, thanks for this solution. I was updating the two anniversary dates using a formula, however, this is a more simpler and a straight forward way of updating it.

Uthpala_K
6 - Meteoroid

Thanks @atcodedog05 , this is great. However, had to use another tweek to update the bi annual dates to 01/01 & 01/07.

Qiu
20 - Arcturus
20 - Arcturus

@Uthpala_K 
Good to know it helps and Thank you for the mark.

Labels