Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Cannot change date format of "Mount Rainier" sample data

Yoshiro_Fujimori
15 - Aurora

Hi,

I recently signed up for one month trial of Alteryx Designer Cloud, and started "Designer Cloud Core" course.

https://community.alteryx.com/t5/Learning-Paths/Designer-Cloud-Core/ta-p/1045768

 

At lesson 39 "Join",

https://academy-cc.alteryx.com/vault/5365b8d1-b997-4500-873c-197e71bce59d/courses/b304f868-0a6d-44f1...

I have a trouble in following the operation on the video.

 

The video shows Date field of "climbs2014" as below (MM/dd/yy)

Yoshiro_Fujimori_0-1679284677479.png

 

But I see my screen as below.(d-MMM-yy)

Yoshiro_Fujimori_1-1679284787754.png

As this cannot be joined with "rainer_weather", I tried to chagne the Date format to MM/dd/yy.

Yoshiro_Fujimori_2-1679284927030.png

But it resulted in all "null" as below.

Yoshiro_Fujimori_3-1679284947891.png

Could you advise what is wrong with my operation?

1 REPLY 1
DataNath
17 - Castor

Strange @Yoshiro_Fujimori - have just tried this myself and seems to work fine. If you try to make a new field with a DATEFORMAT() calc does that work, rather than overwriting the existing field? Could also try using a single M and d as M/d/yy but from what I can see what you're doing should work unless we're overlooking something simple!

 

DataNath_0-1679303828474.png