6 Replies Latest reply: Feb 28, 2018 11:21 AM by celine xu RSS

    join two file with datetime but datetime have different format and content

    celine xu

      Hi , I have 2 file from 2 system so have the datetime with different format

      as follow

      Screen Shot 2018-02-28 at 10.02.51.png


      is that the case I need to change the righthand side datetime format?

      I also have date, time, and the_hour_of_a_day exist in the file.

      if datetime not working, could I use 'Date' and 'time' join at the same time to represent the datetime?


      if I can, how?


      and if I have the right format


      could i use both datetime and also the other floor to join the data together? (inner join will be nice)


      here is the app with the data for your info


      Thank you!