Find week ending on sunday

Hey All,

I got a list of Employees with a date [field] with over 2 years date (daily). I used DateTimeFormat([Date], "%W") to get the week number ending Sunday, I would like a new field that will display the actual date ended on Sunday

for example 1/24/2021, week = 3,

Desired result ->week ending date = 1/24/2021.

I tried generate rows function but with millions of records its slowing down the workflow.

Thanks.

Help

Accepted answers

randreag

well, I'm not sure if I undestand correctly but you can join after the summarize by the week already calculated

All comments

randreag

hi @BosKev

You could calculate just the dates for sundays

Something like the example

ExampleSunday.yxmd

BosKev

Thanks, forgot to mention there are several metrics fields I'm using the summarized tool to sum up to the weekly total.

Weekend date would ideally be attached after the sum function...I would loose the date field. end result would be something like below:

Year; Week; Week End Date; metric 1,2,3

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703