Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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

SandroGerber
8 - Asteroid
Spoiler
SandroGerber_0-1681847043828.png

 

ehuitron
6 - Meteoroid
Spoiler
challenge367_Spoiler.JPG
takoda
Alteryx
Alteryx

Here is my solution:

Spoiler
Weekly Challenge 367 SS.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1681864150068.png

 

 

Designer Experience

Spoiler
AkimasaKajitani_0-1681867191592.png


Desiger Experience has no DateTimeTrim function. So I use some expressions to make it.

 

ArnaldoSandoval
12 - Quasar

@AkimasaKajitani 

 

Exploring the solution you posted, I did not find the macro 🙁

 

Arnaldo

ArnaldoSandoval
12 - Quasar

 

This is my solution 🙂

SpoilerSpoiler

AkimasaKajitani
17 - Castor
17 - Castor

Hi @ArnaldoSandoval 

 

That macro is Expected Equall macro which is a part of CReW Macro. It's a very useful macro pack. Please download and use them from the url below.

http://www.chaosreignswithin.com/p/macros.html

 

bobd
8 - Asteroid

I used trifacta to solve this challenge

hansfinesse
8 - Asteroid
Spoiler
hansfinesse_0-1681890126119.png

 

CasperBuenting
7 - Meteor
Spoiler
CasperBuenting_0-1681892562645.png

 

Fun one!