Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

DateTime Reporting

Highlighted
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
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