Generate Anniversary Dates using generate row tool

[Uthpala_K]

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)

Thank you

Uthpala

[Qiu · Accepted solution]

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

[atcodedog05]

Hi @Uthpala_K 

Here is a workflow for the task.

Input:

Output:

Workflow:

Generate row tool config:

Hope this helps 🙂

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

[Uthpala_K]

@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]

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

[Qiu]

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