Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #34: Date-Time Formatting

AMansour
11 - Bolide

Hi 

 

here's my solution 

 

Spoiler
Capture d’écran 2020-04-29 à 21.12.42.png

cheers

Amr

KGS
8 - Asteroid

Hi,

 

My solution attached. 

 

 

Best,

 

G

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

terry10
12 - Quasar

TBH, the automatic conversion worked without the issue described in the challenge. Perhaps the DateTime tool was improved since the challenge was originally posted.

Sylvana
8 - Asteroid

A simple solution:

Spoiler
Sylvana_1-1588854234192.png

 


 

AlexC2
8 - Asteroid

solution attached

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

Using  STRCSPN made this exercise very simple.

 

Spoiler
Challenge_34_Emil_Kos.PNG
cc000072
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_34.JPG
Treyson
13 - Pulsar
13 - Pulsar

In the original download file it says this is week 33. Macros are fun. I remember early on this attaching a dropdown to a macro input blew my mind.

Treyson Marks
Managing Partner
DCG Analytics
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590160370699.png