End Of Month Formula

Question

Can anyone help me to convert this excel formula into alteryx formula? I have no idea bout this

=MIN(IF(OR(AND(DAY([Eff Date])=28;MONTH([Eff Date])=2);AND(DAY(([Eff Date])=29;MONTH([Eff Date])=2));EOMONTH([Eff Date];12);DATE(YEAR([Eff Date])+1;MONTH([Eff Date]);DAY([Eff Date])));[Exp Date])

mst3k · Answer

a single multi-field formula can do EOM for all your fields, see attached.

assuming your dates start in text format, the formula is:

todate(datetimetrim(datetimeparse([_CurrentField_],'%d/%m/%Y'),'lastofmonth'))

If you don't want new fields created, but you just want to replace the existing values, then deselect the "Copy Output Fields and Add" in the multi field tool configuration

end_of_month.yxmd

meitata · Answer

Eff DateExp DateOutput18/01/201918/01/202018/01/202022/01/201922/01/202022/01/202023/01/201923/01/202023/01/202024/01/201924/01/202024/01/202024/01/201924/01/202024/01/202003/02/201903/02/202003/02/202004/02/201904/02/202004/02/202005/02/201905/02/202005/02/2020

That's one, the first and second row are input.

atcodedog05 · Answer

Hi @meitata

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.