Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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?

Highlighted
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