Date Formula Population/conversion

[agimpel]

i am trying to populate every date within a certain range and for that date format to be mm/dd/yyy time (1/1/2018 12:00:00 AM). in my logic say i want to populate every date from 1/1/2018 - 12/31/2023 and so therefore it should give me every hour within that day. i have attached a two day example of how i want my data to be formatted. is there a way in alteryx to create a formula to populate every date within my range and in this format? i am trying to put together a workbook from within alteryx. TIA! 

[alexnajm · Accepted solution]

Here you go - first the generate rows tool can create all those hours, then the Formula tool formats it the way you want

[JosephSerpis · Accepted solution]

Hi @agimpel you can use the generate rows tool to tackle your challenge.

[Raj · Accepted solution]

@agimpel 
find the workflow attached.
hope this helps