DataGraph Community

Join date and time columns

DataGraph Forums › Technical Support › Support Desk › Join date and time columns

Tagged: , , , ,

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • January 20, 2020 at 3:00 pm #3108
    rvalenzuela
    Participant

      Hello,

      I have a column with dates and another with times. I need to join them into a new column to use as an x-coordinate variable. What I have tried so far is summing the date and time columns but it gives me a wrong datetime.

      Screen Shot 2020-01-20 at 11.59.03

       

      January 20, 2020 at 5:37 pm #3110
      dgteam
      Moderator

        Try using the ‘Fixed Day’ option as shown below …

        2020-01-20 Date and Time

        FYI — The Date column contains seconds form the reference date of midnight of January 1st 1970.  The ICF Format is using the day of January 1st, 2000.  This is not expected behavior and something we will look at changing, but for now using the Fixed day format should work.

         

        January 20, 2020 at 6:20 pm #3112
        rvalenzuela
        Participant

          Thanks! It worked!

        • Author
          Posts
        Viewing 3 posts - 1 through 3 (of 3 total)
        • You must be logged in to reply to this topic.

        DataGraph Forums › Technical Support › Support Desk › Join date and time columns