How to merge Date and Time field and convert into Single field.

[Vinod]

Hi All.

How to merge or Combine Date and Time field and Convert into Single column. Time field is already in minutes and seconds. It should display with colon.For Example 8/2/2019 for this date time is 1130. and It should Display as 11:30.

For your reference i have attached sample file.

Thanks.

[tresesco · Accepted solution]

Try like:

Timestamp(DATE+Time#(TIME, 'hhmm')) as TimeStamp

[durgesh22]

Try below,

Timestamp(Date#(CDATE,'MM/DD/YYYY') +Time#(TIME, 'hhmm')) as TimeStamp

it is working for me.