Find week ending on sunday

[BosKev]

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.

[randreag]

hi @BosKev 

You could calculate just the dates for sundays 

Something like the example

[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

[randreag · Accepted solution]

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

[BosKev]

Thanks!