Challenge #367: Manipulating Dates – End of the Month

[AYXAcademy]

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.

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]

Here is my solution.

Spoiler

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

Spoiler

[DataNath]

My solution to #367.

Spoiler

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

Spoiler

 Alteryx Designer Cloud:

Spoiler

[Flo_P]

Spoiler

Fairly straightforward

[benjimoser]

My Solution:

Spoiler

[TimJVR]

Spoiler

[braveraj]

Spoiler

 

[MilindG]

Spoiler

Output file has some incorrect results

[gaoa]

Spoiler

[cjaneczko]

Spoiler