Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

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.

 

3 REPLIES 3
JosephSerpis
17 - Castor
17 - Castor

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. 

yashwanth522
7 - Meteor

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

MarqueeCrew
20 - Arcturus
20 - Arcturus

@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.
Labels