Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

End Of Month Formula

meitata
7 - Meteor

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

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @meitata 

 

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

meitata
7 - Meteor
Eff DateExp DateOutput
18/01/201918/01/202018/01/2020
22/01/201922/01/202022/01/2020
23/01/201923/01/202023/01/2020
24/01/201924/01/202024/01/2020
24/01/201924/01/202024/01/2020
03/02/201903/02/202003/02/2020
04/02/201904/02/202004/02/2020
05/02/201905/02/202005/02/2020

 

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

mst3k
11 - Bolide

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

 

mst3k_0-1632730366728.png

 

Labels