Skip to main content

How to Merge Date and Time

  • September 29, 2019
  • 3 replies
  • 30 views

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}

This topic has been closed for replies.

3 replies

Forum|alt.badge.img+19
  • Inspiring
  • September 29, 2019

@JAZ_Yadao,

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


  • Author
  • New Participant
  • September 29, 2019

heya Bill,

Yes. That’s right.


Forum|alt.badge.img+19
  • Inspiring
  • September 29, 2019

heya Bill,

Yes. That’s right.


Okay - this should make it right:

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