Getting the Current Date and Last Week Date Record

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

Getting 6 days Current and Previous.xlsx

Workflow

Date Time

Accepted answers

Qiu

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

0708-KamenRider.yxzp

All comments

Qiu

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

0708-KamenRider.yxzp

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.

0708-KamenRider-r1.yxmd

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😁

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177