Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Explanation of %Y, %M, %d--- %H|%M|%S

Bobbiconway
8 - Asteroid

I was just working on the Try It exercises for Date Time in the Getting Started Learning Path. The final problem was resolved by putting %Y, %M, %d--- %H|%M|%S in the custom settings. However, I'm new to Alteryx. I don't understand why the % was used. 

3 REPLIES 3
binuacs
21 - Polaris

@Bobbiconway That is the syntax of the datetime function, you can find more details in the below link. Also in your example you need to use %Y, %m, %d--- %H|%M|%S where %m represent the months and %M represent the minutes

 

DateTime Functions | Alteryx Help

 

binuacs_0-1653598628197.png

 

Bobbiconway
8 - Asteroid

Thank you for the help. Is it just a shortcut? Am I getting that right?

binuacs
21 - Polaris

@Bobbiconway I would call it is the syntax of the datetime function, for example %m/%d/%Y gives the date in the format mm/dd/yyyy adn %m/%d/%y give the date in the format mm/dd/yy

Labels