Adding a date and time together

VeronicaElse

Can you add a date column and a time column together to create a new column as one?

Date Time

Accepted answers

JagdeeshN

@VeronicaElse

Please find attached a sample workflow which converts this format.

Do let me know if this helps.

Best,

Jagdeesh

sample.yxmd

All comments

JagdeeshN

Hi @VeronicaElse ,

If both these columns are of the string datatype currently, you can do a string concat using the formula tool. The formula would be 'Date_String'+" "+'TIme_String' . Post this you can DateTime parse tool to convert the string into a datetime datatype.

Do let me know if this helps.

Best,

Jagdeesh Narayanan

VeronicaElse

Hello,

Thanks for replying!

I inputted the two fields into the formula provided (they were both VString) and added the DateTime parse tool to convert to datetime datatype and my output is NULL.

Any reasons why?

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335