SOLVED
How to retrieve third Friday of a month?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
yashwanth522
7 - Meteor
‎09-26-2019
11:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
- Help
- Preparation
- Time Series
- Workflow
3 REPLIES 3
17 - Castor
‎09-26-2019
12:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎09-26-2019
12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Awesome! @JosephSerpis Worked like a charm! Great idea!
20 - Arcturus
‎09-26-2019
12:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Cheers,
Mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
