Calculate 1-month ahead estimate based on field

Question

Hi,

I need to trigger an existing formula tool after 1 month from the current date, if it doesn't have any date after a month.

Currently, I calculate 1 month ahead estimate which is calculated based on 6-month MA formula tool.

I need to trigger the same formula tool again to calculate another 1 month estimate if i dont have date after a month from current invoice date.

Find example here,

Emmanuel_G · Answer

Hi @Ronal_bal ,

I don't know if I understood the concern correctly, but you can arrive at the calculation of the estimated value one month later with an iterative macro.

You will find it attached.

Please tell me if it works or not or if there is something to modify.

Cheers !

Calculation of estimate after 1 month.yxzp

taylor_butler · Answer

Hi @Ronal_bal,

I would recommend checking out the DateTime Functions (DateTime Functions | Alteryx Help), specifically DateTimeAdd. This formula will allow you to add a specific interval to a date, so in your use case, you could configure it to be DateTimeAdd(DateTimeToday(), 1, "months") to add a month to the current date. If there is another date you'd prefer as the parameter, rather than adding a month from the current date, simply replace the first parameter with that date in Alteryx DateTime format (YYYY-MM-DD).

Hope that helps!

Taylor