Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try like:
Timestamp(DATE+Time#(TIME, 'hhmm')) as TimeStamp
Try below,
Timestamp(Date#(CDATE,'MM/DD/YYYY') +Time#(TIME, 'hhmm')) as TimeStamp
it is working for me.