We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #367: Manipulating Dates – End of the Month

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.

 

To solve this week’s challenge, use Designer Desktop, Designer Cloud, Trifacta Classic, or Designer Cloud, Designer Experience.2023-04-17_07-54-00.png

 

Almost any data project will include dates. Working with dates is a common task and is important for downstream tasks such as reporting. In this week's challenge, we introduce another date manipulation you may encounter.

 

In this scenario, you distributed time-sensitive coupons to your customers, but never recorded their expiration dates. Customers must use them by the end of the month they were issued. Using the dataset provided, generate a column that finds the last day of the month from a given date. For example, for the date 3/13/23, your output is 3/31/23.

 

 

PhilipMannering
16 - Nebula
16 - Nebula

Here is my solution.

 

Spoiler
PhilipMannering_0-1681743511470.png

 

Solution in the Python Tool (def prefer working with dates in Alteryx).

 

Spoiler
PhilipMannering_0-1681810647703.png

 

DataNath
17 - Castor

My solution to #367.

 

Spoiler
DataNath_0-1681743768794.png

 There are, however, 29 incorrect records in the expected output. These aren't month ends (spoiler below):

 

Spoiler
DataNath_0-1681743930229.png

 Alteryx Designer Cloud:

 

Spoiler
DataNath_0-1681750878140.png
Flo_P
8 - Asteroid
Spoiler
Fairly straightforward
Flo_P_0-1681743816750.png
benjimoser
9 - Comet

My Solution:

Spoiler
benjimoser_0-1681743840899.png

 

TimJVR
7 - Meteor
Spoiler
TimJVR_0-1681744521759.png

 

braveraj
10 - Fireball
Spoiler
braveraj_2-1681744650776.png braveraj_3-1681744669055.png

 

 


 

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1681744743622.png

 

Output file has some incorrect results

gaoa
11 - Bolide
Spoiler
gaoa_0-1681745009994.png
cjaneczko
12 - Quasar
Spoiler
cjaneczko_0-1681745064932.png