Generate Anniversary Dates using generate row tool

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

Help

Accepted answers

Qiu

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

1016-Uthpla_K.yxmd

All comments

Qiu

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

1016-Uthpla_K.yxmd

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 😀👍

bi anual.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703