Displaying data based on the current day of the week

[Deano478]

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. 

[Luke_C · Accepted solution]

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()

[binuacs]

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

[Deano478]

@binuacs 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? 

[binuacs]

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

[Deano478]

@binuacs @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  😁