Filter data for last weekday of the month

Hello,

I was wondering if there was a way to filter a data set in Alteryx to only display the last weekday of a certain month.

For example, if I have data whose items have corresponding dates of all of August (and nothing but August) and I want it to filter out everything but 8/30/2019 (since 8/31/2019 is a Saturday), would that be possible?

Thanks!

Date Time

Help

Accepted answers

BrandonB

I think that this should do the trick. The branch of the workflow at the bottom determines the last day of the month of data and then uses another formula to determine if that day is a Saturday or Sunday to go back to the closest weekday. Let me know if this helps. Workflow attached!

Filter last weekday.png

Filter last weekday workflow.yxmd

All comments

benakesh

Hi @wht822 ,

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

datetime format with %a or %A will give Fri or Friday for all dates .

Summarize and filter for maximum Friday date.

Join data to extract records with max Friday date .

Fri1.yxmd

philipmannering

Hi @wht822 ,

Alternative solution for you. See attached.

Last Weekday.yxmd

BrandonB

Filter last weekday.png

Filter last weekday workflow.yxmd

wht822

Very helpful. Thanks!

wht822

Had to tweak this one to fit my specifications but I ended up using this. Thanks! This helped a lot considering I'm relatively new to Alteryx. Any chance you know of a way to run this workflow multiple times, so every spreadsheet in a certain file runs through the workflow with a separate output for each one?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703