Getting the Current Date and Last Week Date Record

[KamenRider]

Hi Alteryx Community,

I would like your help in obtaining records for the current six dates and the previous six dates. In my attached example, the current six dates range from June 27 to July 7, while the previous week's records span from June 26 to July 3. We will then calculate the total number of rejects for each category in both the current and previous records

Note: posting this again since I accidentally click the "solve solution" button.

Hoping anyone to provide me solution on this.

Thanks,

Kamen

[Qiu · Accepted solution]

@KamenRider 
I hope I understand your intention correctly and made a sample flow.
My current Day is July-8 so I have to "hard code" it but you can use the Function of DateTimeToday.

And the previous week should be  June 30 to July 4, right?

[KamenRider]

Hi @Qiu 

Thank you for your response. When identifying the six dates, they should range from June 26 to July 7 (starting date). This will be based on the records, and you'll notice that July 4 is missing. I agree that using DateTimeToday() for the CurrentDay is a good approach. For the previous week, it will move backward by counting six dates, resulting in a range from June 26 to July 3. There are no records for July 4 because it is a holiday. See my screenshots above.

Looking forward for your response.

Thanks,

Kamen

[Qiu]

@KamenRider 
So you are counting 6 working dates ( existing in the Excel) back, not the calendar dates.
If so, I am getting the different answer with your Excel again.
Kindly check where I am missing, and the current flow should get you going.

[KamenRider]

HI @Qiu 

Thanks for the response. In some how you get the current and previous week which are very much helpful. I think I know what to do.

Thanks for your assistance.

Kamen

[Qiu]

@KamenRider 
Glad to be any help😁