FormuHello, I am trying to create a formula and filter data through the last Sunday. For example, the last Sunday was 8/11/24 so then everything after that is filtered out and everything 8/11/24 and before is kept. Here is an example data that I have. DateID8/13/202421978/12/202429088/11/202427048/10/202476948/9/202462408/8/202424018/7/202479448/6/202415858/5/202483518/4/202452938/3/202456678/2/202465028/1/202476627/31/202460327/30/202415807/29/202428857/28/202431417/27/202451987/26/202449807/25/202428477/24/202436567/23/202416577/22/202441477/21/202438797/20/202490787/19/202473387/18/202461267/17/202482797/16/202480227/15/20243702 Best, Bryan

How can I filter data through the last Sunday

FormuHello,

I am trying to create a formula and filter data through the last Sunday. For example, the last Sunday was 8/11/24 so then everything after that is filtered out and everything 8/11/24 and before is kept.

Here is an example data that I have.

Date	ID
8/13/2024	2197
8/12/2024	2908
8/11/2024	2704
8/10/2024	7694
8/9/2024	6240
8/8/2024	2401
8/7/2024	7944
8/6/2024	1585
8/5/2024	8351
8/4/2024	5293
8/3/2024	5667
8/2/2024	6502
8/1/2024	7662
7/31/2024	6032
7/30/2024	1580
7/29/2024	2885
7/28/2024	3141
7/27/2024	5198
7/26/2024	4980
7/25/2024	2847
7/24/2024	3656
7/23/2024	1657
7/22/2024	4147
7/21/2024	3879
7/20/2024	9078
7/19/2024	7338
7/18/2024	6126
7/17/2024	8279
7/16/2024	8022
7/15/2024	3702

Best,

Bryan

Workflow

Date Time

Transformation

Accepted answers

Yoshiro_Fujimori

@bryanmac_92 ,

For your convenience, you can use this expression in Filter tool.

DateTimeParse([Date], "%m/%d/%Y") <=

DateTimeAdd(
DateTimeToday(),
- ToNumber( DateTimeFormat( DateTimeToday(), "%w") ),
"day"
)

All comments

OTrieger

Hello @bryanmac_92

With the use of DateTimeFormat([Day],"%a") you will get the day Mon to Sun. Then add today date DateTimeToday().
Now you can filter any date that prior to today. Then with Summarize tool you could find the Max date grouping on days and there you have last Sunday.