time conversion to HH:MM:SS and concatenating date and time

[Wafarian]

Hi,

I am new to alteryx and I have a requirement to convert time to right format ( HH:MM:SS ) and concantenate date and time.

below is  my sample date and what I have done so far.

how can I resolve this issue.

thanks

[ShankerV]

Hi @Wafarian 

You can do this with the help of Date time tool and Formula tool.

Many thanks

Shanker V

[ShankerV]

Hi @Wafarian 

Please find the expected output:

Hope your issue is resolved. Feel free to mark helpful answers as a solution, so that future users with the same issue can find them easier!!!!

Many thanks

Shanker V

[Wafarian]

Hi,

do you have a formula example ?

thanks

[ShankerV · Accepted solution]

@Wafarian 

I have also redesigned the output to show all the date, time and Date time also.

Kindly let me know if you have more questions.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @Wafarian 

I have attached my complete workflow, so that you can open and see the formula.

Pasting below once again for your reference:

Many thanks

Shanker V

[Wafarian]

Thank you very much. That is exactly what I need.

[ShankerV]

@Wafarian 

Welcome, happy to support anytime.