Hours to datetime

Question

Hello,

I have 8760 rows per year and I would like to convert them to datetimeformat in Alteryx (taking into account daylight savings time). Is there any way to do this?

hour of the yearyearWhat I want1

20202020-01-01 00:00:0022020

2020-01-01 01:00:00

320202020-01-01 02:00:00420202020-01-01 03:00:00520202020-01-01 04:00:00620202020-01-01 05:00:00720202020-01-01 06:00:00820202020-01-01 07:00:00920202020-01-01 08:00:0010 20202020-01-01 09:00:001120202020-01-01 10:00:001220202020-01-01 11:00:001320202020-01-01 12:00:001420202020-01-01 13:00:001520202020-01-01 14:00:001620202020-01-01 15:00:001720202020-01-01 16:00:001820202020-01-01 17:00:001920202020-01-01 18:00:002020202020-01-01 19:00:002120202020-01-01 20:00:002220202020-01-01 21:00:002320202020-01-01 22:00:002420202020-01-01 23:00:002520202020-01-02 00:00:002620202020-01-02 01:00:002720202020-01-02 02:00:00...2020...87602020

2020-12-31 23:00:00

Hannah_Lissaman · Accepted Answer

Hi @DADE

This is a perfect use for the Generate Rows tool. You can use this to generate all hours in a year from scratch.

For the daylight savings part of your request, you will need to add the start and end times of daylight savings as an input. You can then use a Formula tool with an if statement to check whether a date falls within the period, and add 1 hour if it does.

I have attached my workflow for you.