How to Merge Date and Time

[JAZ_Yadao]

Hi Guy,

Appreciate if you could help me figure out the correct formula to use in order to fix the time format for the below.

I need to merge the time and date which i did however the time format should be h:mm.
1|690x357

Btw, i used this formula: DATETIME_FORMAT({Old Date},‘MM-DD-YYYY’)&" "&{Old Time}

[Bill_French]

@JAZ_Yadao,

It appears you are merging a date with a duration field to get a specific point in time, right?

[JAZ_Yadao]

heya Bill,

Yes. That’s right.

[Bill_French]

JAZ_Yadao:

DATETIME_FORMAT({Old Date},‘MM-DD-YYYY’)&" "&{Old Time}

Okay - this should make it right:

DATEADD({Old Date}, {Old Time}, 'seconds')