This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We frequently report on our data by week. However, the DateTimeTrim function (in the Formula Tool and others) does not support this trim type.
Some workarounds have been posted that involve calculating the day of the week and then subtracting it out:
It would be very helpful to update DateTimeTrim as follows:
I have a 'WeekStart' function in my function library: https://github.com/jdunkerley/AlteryxFormulaAddOns
At moment rounds to Sunday but easy to expand to include a weekday parameter. Happy to send you if would work for you.
Just had a chance to check out your function library, jdunkerley79. It's extremely helpful, and it includes other functions (like IFNULL) that are not native to Alteryx.
Thanks for sharing it!
Thanks for submitting this idea! I am currently looking into additional functions we should add to the expression editor. If you have any ideas for other functions please let me know the function and the category (existing or new).
Thanks again for submitting an idea to the Ideas forum.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.