Cannot change date format of "Mount Rainier" sample data

[Yoshiro_Fujimori]

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)

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

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

But it resulted in all "null" as below.

Could you advise what is wrong with my operation?

[DataNath]

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!