DateTimeFirstOfWeek() Formula Function

[Joe_Lipski]

As there is a DateTimeFirstOfMonth() Formula function is there any reason why there is not or could not be a DateTimeFirstOfWeek() equivilant.

Thanks,
Joe

[Ned]

Like many things in Alteryx, it is possible already with combining other features:

DateTimeAdd([Field1],-ToNumber(DateTimeFormat([Field1],"%w")), "Days")

You might need to adjust the second parameter to whatever your definition of the start of the week is.

[Joe_Lipski]

Thanks for the response Ned,

A new client was looking for an easy to use formula function and wondering why there wasn't such a thing.

I had suggested a very similar formula to what you recommend.

Thanks,
Joe