Help to verify the script result If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1, 0)

[Anonymous]

Please kindly help me to verify the result of this script.

LET RunQuarterly = If( Mod(Num(Month(AddMonths(MonthEnd(Today()), -1))),3) = 0, 1, 0);

Thank you very much in advanced.

[tresesco]

The code returns 1 if last month is a multiple of 3 else 0. However, the same can be achieved with a little simpler expression (removing few unnecessary functions), like:

LET RunQuarterly = If( Mod(Month(MonthEnd(Today(), -1)),3) = 0, 1, 0);

[agni_gold]

What exactly you want to do ?