Adding days

Question

Greetings,

I have the same problem. I want to create a new column where I add a day if the products change. For example

I need this

I was using the multi-row formula with datetimeadd(max_Date,1,"days") but I don't get the correct result.

Thanks for your help!!

MarqueeCrew · Accepted Answer

@MaPerez,

Here's a quick picture of the configuration that you're looking for:

Notice that there is a GROUP configuration by PRODUCT!

IIF([Product]!=[Row-1:Product],DateTimeAdd([Max_Date],1,"Days"),DateTimeAdd([Row-1:New_Date],1,"Days"))

If the product on the row isn't the same as the product above it, then add 1 day to the Max_Date.  Otherwise add one date to the prior result.

Cheers,

Mark

Kenda · Accepted Answer

Hey @MaPerez!

To solve this, I first created an ID field using a Multi-Row Formula Tool and grouping by Product.

I then added a second Multi-Row Formula tool to check if the ID is 1 - if so, add one day to the max date, otherwise add one day to the new date in the row above. Also group by product here.

Hope this helps!