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.
SOLUCIONADO

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

Bobbiconway
Asteroide

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 RESPOSTAS 3
binuacs
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
Asteroide

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

binuacs
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

Rótulos
Autores com maior número de soluções