Join date and time columns

Welcome to our Forums Technical Support Support Desk Join date and time columns

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #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

       

      #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.

         

        #3112
        rvalenzuela
        Participant

          Thanks! It worked!

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

        Welcome to our Forums Technical Support Support Desk Join date and time columns