4 Replies Latest reply on Oct 3, 2018 6:40 AM by Manish Chauhan

    Convert Hour and Date into Datetime

    Geoffrey Bell

      Seems that there are no shortage of discussions related to this but I couldn't find one that quite fit my need.

       

      I have hour and date columns but what I'd like to do is convert them to a single datetime column. I've attached a screenshot as well as some sample data.

       

      Apologies if this is a repeat question but there are tons of questions on the forum about date and time translation (understandably).

       

      Hour and date are from my source data. All the calculated fields are failed attempts I've made.