DateTime Reporting

[henrygeorge]

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

[MarqueeCrew · Accepted solution]

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

look for the specifiers 

cheers,

 mark

[henrygeorge]

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

[MarqueeCrew]

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