2 Replies Latest reply on Nov 20, 2013 4:57 PM by Shawn Wallwork

    date and time

    Alexander Rom




      So, i've been trying to combine date and time into a single field, and the above calc. field isn't working. here is what I have


      One excel column is 'Date' (1/11/2013) the other is Time of Day (only top of the hour) stylized as 8:00pm tableau translates it to military time, but I digress. I wrote the below calc. field and I keep getting NULL for my values





      I am trying to show GA site visits by day by hour


      DATETIME(STR([Date] )  + " "

      + STR(DATEPART('hour',[Time of Day])))


      Any insight would be great as the Tableau Tech Support always seems to be non-existent lol