Hi Everyone,
Is there a way for me to do the operation below in alteryx?
so i have the computation below:
so the excel syntax is: =IFERROR($D2-(WEEKDAY($D2,2)-1),"""")
I am new in alteryx and I don't have an idea how to calculate it using alteryx
Hope someone can help me.
thanks in advance 🙂
Solved! Go to Solution.
An equivalent expression would be:
DateTimeAdd([Date],1-ToNumber(DateTimeFormat([Date],"%u")),"days")
- DateTimeFormat([Date],"%u") will give you the WeekDay(,2) equivalent as a string
- ToNumber parses it to a number
- DateTimeAdd allows you to add a period to the date
Sample attached
This works great thanks for your help!