Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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