Is there a way to combine a date column and Hour column?
Currently i am trying CONCATENATE({DATE}," ",{Hour})
However Jul 22 and 8:00 AM is populating as Jul 22, 1:00AM.
I can not figure out how to get the time to transfer over correctly.
Please Help @rob
Originally i tried to have a text column that said Jul 22, 8:00 AM, but using, TEXT(DATEVALUE({DateText}),“yyyy-mm-dd”) has not copied the time over to the date column. Only “Jul 22”.
Times are stored and retrieved in UTC format.
So I guess your timezone is 7 hours behind UTC.
Before casting it into the destination column you need to add/remove the corresponding difference in hours.
CONCATENATE({item's Date}, " ", TEXT(TIMEVALUE({item's Hour}) + 7/24, "HH:MM"))
or
CONCATENATE({item's Date}, " ", TEXT(TIMEVALUE({item's Hour}) - 7/24, "HH:MM"))
where 7/24 is the difference calculated as portion of one day (24 hours).
That worked perfectly. Thank you!