Extract hour from a datetime field

[bdlee99]

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!

[Bob_Blackey · Accepted 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

[gc]

Check this out >> https://help.alteryx.com/10.6/Reference/DateTimeFunctions.htm

"%H" in Formula tool to pull out the 2 digit hour.