Hello,
I want to perform the following Excel function in Alteryx: =INT((B2-1)/7)*7+1.
How can I convert this formula into Alteryx syntax so I can use it in the formula tool?
Can I get a result using a different tool too?
@c-yun I think you are trying to get the date of Sunday (as beginning of the week) for the dates list.
Hello @c-yun One way to tackle this would be to add a data time parse tool in, before the formula, to extract the day.After this, you can edit the formula with an If statement, such that if the day = Sunday, then don't change the date, else, do change the date.
Please let me know how you get on.Regards - Pilsner
How can I add an IF statement to your formula that will give me the original start date if the original start date is already a Sunday?
When I enter the formula as it is currently, it gives me the previous Sunday date.
