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])
Hi @meitata
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
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.
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