In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to retrieve third Friday of a month?

yashwanth522
7 - Meteor
‎09-26-2019 11:56 AM

How to retrieve the third Friday of a month? I have a use case where I need to send out emails on a particular day of a month.

 

Reply

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor
‎09-26-2019 12:07 PM

Hi @yashwanth522 the workflow attached will give you for the current month the list of days and ranks them so you can then easily identify the Third Friday of a month. 

Dates_260919.yxmd
Reply
yashwanth522
7 - Meteor
‎09-26-2019 12:18 PM

Awesome! @JosephSerpis  Worked like a charm! Great idea!

Reply
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎09-26-2019 12:19 PM

@yashwanth522 ,

 

I generated a set of future dates and calculate the day of week and then determine which occurrence of that day it is for any given month.  My workflow filters to the 3rd Friday, but it could be anything you want.

 

capture.png

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Third Friday.yxmd
Reply
Labels
Top Solution Authors
View All