Adding a time column to a date column

nlgenin

Hello, Alteryx Gurus!

I need you guys to help me out with a simple task.

I'm starting to use Alteryx and I need to add a column which has the Time of a specific date, to that date column.

So what I need is a new column with date and time together.

I tried the following, but it says the [time] field is not in number, so I could try to convert it to number, right? And then apply the formula

DateTimeAdd(DateTimeParse([date],"%y-%m-%d %H:%M:%S"),[time],"seconds")

Thanks!

atcodedog05

Hi @nlgenin 

You can do something like this.

Workflow:

Hope this helps : )

datetime.yxmd