Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

DateTime Reporting

Highlighted
8 - Asteroid

Hi All,

 

What are the Date Time codes in Alteryx. I really want to the entire list -

eg:- % A - full weekday name

%a - Sat

%B - Full month name

%b - Feb

%d - day of the month

What are the others? Can anyone direct me to the full list?

 

Regards

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm 

 

look for the specifiers 

 

 

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
8 - Asteroid

@MarqueeCrew Whats the difference between %e and %d?

Alteryx Certified Partner
Alteryx Certified Partner

Here's a good article (I wrote it):

 

 

https://community.alteryx.com/t5/Engine-Works-Blog/MarqueeCrew-s-Guide-to-Avoiding-Date-Frustration/... 

 

%e looks for SPACEdigit for January to September. 

cheers,

 

 mark

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels