Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!
Free Trial

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
Top Solution Authors