Challenge #461: Accounting Payment Calendar
- 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
Hello Community members!
A solution to last week’s challenge can be found here.
This week’s challenge was submitted by Jay Zhen @jialiangzhen . Thank you, Jay, for this great challenge!
Imagine you work for a large organization’s accounting department. You are responsible for organizing the payment schedule for the year based on specific dates.
The entire company’s payments must be completed by the 6th workday of each month. You want to use Designer to organize a schedule for the entire year. The provided dataset contains the 2024 calendar and company holidays. Your task is to determine when the 6th workday is for each month in 2024. A workday is defined as any weekday from Monday to Friday (excluding company
holidays).
Note: If you get stuck, check out the Hints box included in the workflow.
Need a refresher? Review the following lessons in Academy to gear up:
Good luck!
The Academy Team
- Labels:
- Core
- Data Preparation
- Intermediate
- 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
Also appears to possibly be some slight errors with the given solution? For example the tenth month is a repeated "1". Fun challenge though!
- 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
Good challenge. Could definitely have used less tools!
- 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
- 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator