Filtering Records on Weekdays and Weekends

[dmadlock2]

Hello,

I have a list of transactions and it gives the date that the transactions were made. I am wanting to filter out and pull transactions made on weekdays and transactions made on weekends, is this possible in Alteryx?

When my excel file is inputted into Alteryx, the "Post Date" format is yyyy-mm-dd. Below is an example, the left column is the transaction number and the right column is date that it happened. Currently it only shows 2018-07-02 because it's only the first 10 records, I have many more with different Post Dates. 

Thank you! 

[AbhilashR · Accepted solution]

Hi @dmadlock2, make sure your column Post Date has a Date datatype, after which you could use the datetimeformat function in formula tool to identify weekday vs. weekends.

DateTimeFormat([Post Date],"%a")

 Something like the attached solution.

[grossal · Accepted solution]

Hi @dmadlock2,

you can use a Formular to convert your date to a weekday:

DateTimeFormat([Post Date],'%A')

Example:

You can than use a Filter Tool to filter out Sunday and Saturday 😃

Best

Alex

[dmadlock2]

Thank you so much, it worked!

[dmadlock2]

Thank you so much, it worked!

[ekarita]

Thank you for this