End Of Month Formula

[meitata]

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])

[atcodedog05]

Hi @meitata 

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

[meitata]

Eff Date	Exp Date	Output
18/01/2019	18/01/2020	18/01/2020
22/01/2019	22/01/2020	22/01/2020
23/01/2019	23/01/2020	23/01/2020
24/01/2019	24/01/2020	24/01/2020
24/01/2019	24/01/2020	24/01/2020
03/02/2019	03/02/2020	03/02/2020
04/02/2019	04/02/2020	04/02/2020
05/02/2019	05/02/2020	05/02/2020

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

[mst3k]

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