I have been playing around with the date time specifiers and am getting confused on how a few of them are different.
Specifically:
What is the difference between %d and %m?
Per documentation, %d is the day of the month and %m is the month number. I get null values when trying to format a string to datetime object using %m.
What is the difference between %H and %k?
Per documentation, %H is hour in 24 hour clock and %k is 24 hours, leading zero is space. I get null values when trying to format a string to datetime object using %k.
today's date is 2021-07-02 in Alteryx.
%d is day of the month (2)
%m is the month (7)
%H is hours (16 - where I am.).
%k is currently 16 - but 12 hours ago - it was 4 - %H was 04.
Try it with datetimenow() and datetimeformat(datetimenow(),"%H") or whatever you want to see the changes.
@qasdxx
The DateTime Function help files should have all we need.
https://help.alteryx.com/current/designer/datetime-functions