How to Merge Date and Time

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.

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


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

1 Like

heya Bill,

Yes. That’s right.

Okay - this should make it right:

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