Combining a Time and Date Field

[Manu1016]

I have two (2) separate columns for Date and Time in the format of yyyy-mm-dd and hh:mm:ss respectively.  Does anyone know how to combine these two (2) separate columns into one (1) column with the format of yyyy-mm-dd hh:mm:ss?

Thanks,

Adam

[MarqueeCrew]

[dare] + ' ' + [time]

Should work into a date/time field.

:) mark

[tcroberts]

Is there a space between those quotes? I was unable to get it to work properly until I added whitespace there:

[Date] + " " + [Time] 

It might just be a bit tricky to read on the screen though

[JonBCOKE]

To clarify this just a touch more

NO:

[Date]+" "+[Time] 

Without spaces on either side of the pluses does not work.

YES

[Date] + " " + [Time] 

 There must be spaces next to the pluses.

[Bilbottom]

@JonBCOKE  Not sure if that was true at the time, but it's not true anymore -- Alteryx doesn't care about the spaces between the operators. The only important thing is that a space ends up between the [Date] value and the [Time] value