DateTimeFirstOfWeek() Formula Function

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

Thanks,
Joe

Not Planned

Desktop Experience

Category Preparation

Comments

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

RachelW