I have attached a file with i/p and expected o/p( in yellow background). If there is HBT in reference then the date in Reference is o/p else we have to add 1 month to date to get o/p can anyone help? I also attached excel file. Thank you.
Solved! Go to Solution.
Hi,@srk0609
FYI. ( In your want output , the "22" is year or day ? )
IIF(Contains([Reference], "HBT"), DateTimeAdd([Date],ToNumber(REGEX_Replace([Reference], "[\D]", ""))-1,"day"), DateTimeAdd(DateTimeAdd([Date],ToNumber(REGEX_Replace([Reference], "[\D]", ""))-1,"day"),1,"month"))
Hi @flying 008,
The 22 is year. Thank you for the help. I will review the wf you provided.
Hi,
In my alteryx designer I have a column with value 31-MAY-22 and I want to convert it to date 2022-05-31 so that I cn use your formula. Can you please help? Thank you
Thank you for your help
Hi DataNath,
Could you please help me with this issue? Thank you
User | Count |
---|---|
19 | |
15 | |
15 | |
9 | |
8 |