Displaying data based on the current day of the week

Hello fellow Alteryx Enthusiasts,

I have a bit of an issue I'm trying to figure out with my data, Basically what I need to do is display User indexes for the current day of the Year we are on so for example if its 09/11/2022 then I need to be able to display the indexes for that day and then all other subsequent dates that follow. My apologies if this is a stupid question to be asking.

Below is a small extract of the data I'm working with:

Submission_Date	Email	Activity_Index	Return	Repeat_Index	Day_of_Week
28/02/2022	Joe.Twain@test.com	3	[Null]	0	Monday
18/10/2022	Mike.Wallace@test.com	5	[Null]	0	Tuesday
02/06/2022	angela.Coyne@test.com	5	[Null]	0	Thursday
26/09/2022	Joanne.Grant@test.com	3	[Null]	0	Monday
25/11/2021	Isiah.Smith@test.com	4	[Null]	0	Thursday

Any guidance is much appreciated guys and gals.

Workflow

Accepted answers

Luke_C

Hi @Deano478

Maybe a filter like this is what you're looking for? All your dates are in the past so I added a future date to test..

DateTimeParse([Submission_Date],'%d/%m/%Y') >= DateTimeToday()

All comments

Luke_C

Hi @Deano478

Maybe a filter like this is what you're looking for? All your dates are in the past so I added a future date to test..

DateTimeParse([Submission_Date],'%d/%m/%Y') >= DateTimeToday()

binu_acs

@Deano478 Can you provide expected result based on your input ?

Deano478

@binu_acs its hard to show it but basically for every user I need to show their Index for the current day so today for example id need to show everyones index for today only if that makes sense?

binu_acs

@Deano478 sorry I'm not following,if you could give some examples based on the given dates that would b helpful to understand

Deano478

@binu_acs @Luke_C I appreciate both of your contributions but after taking a step back I solved the issue it wasn't as difficult as I thought 😁

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703