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
20 - Arcturus

@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
20 - Arcturus

@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