Filter data based on current week (weekdays)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I would like to filter out outside of the current week (weekdays).
Example, if i run the flow on the Thursday of this week, i would like to only keep results from Monday to Thursday. If Friday, then Monday to Friday. If Wednesday, then Monday to Wednesday. Exclude any Saturdays and Sundays, and prior weeks.
Solved! Go to Solution.
- Labels:
- Date Time
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@atcodedog05 This certainly works, however, for review purposes I tend to prefer a more documented approach.
I separate the formulas from the conditions being filtered using a formula tool to create weekdays / week no and a filter tool to filter on the conditions that should be met. See the attached workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you for the rec! wondering why 02/28 was excluded
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
also i need the original list of dates to be dynamic based on current week, not as a input data tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @pateldev22
@atcodedog05's solution is dynamic. The datetimetoday function returns the current date. The %u returns a numeric day of week (Monday is 1, Sunday is 7).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
have not had my morning coffee yet. clearly we need the input data tool as a population data set. LOL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @pateldev22
Cheers and have a nice day!
