Hello,
I need to extract the hour from a datetime field into a new column. The current format is YYYY-MM-DD HH:MM:SS.
Any help would be greatly appreciated!
Solved! Go to Solution.
Hi,
Use a FORMULA tool, set the field type to String and set the formula to:
DateTimeFormat([YourField],"%H") - where [YourField] is the field with the date time
Cheers,
Bob
Check this out >> https://help.alteryx.com/10.6/Reference/DateTimeFunctions.htm
"%H" in Formula tool to pull out the 2 digit hour.