Date MultiRow Logic

[Randell9845]

Hello!

How can I do the logic in the file? I want it so that every time the date1 and date2 month integers would be equal, it should default to a value of 12 and the succeeding rows would be Row - 1. Thanks!

[Bobbyt23 · Accepted solution]

You could use this formula in the multi row tool:

IF DateTimeMonth([Date1_Out]) = DateTimeMonth([Date2_Out])
THEN 12
ELSE [Row-1:Integer]-1
ENDIF

Making sure your date fields are dates first.

You will just need to tweak the formula to handle anything that comes before the first match instance though so they aren't negative, depending on how many you have above etc.