5 Replies Latest reply on Dec 6, 2013 9:41 PM by Prashant Sharma

    Joining tables by Calculated Field

    Dawid Nawrot

      I've read few threads about it but those didn't really answered my question.

       

      I've got two tables, orders placed and orders rejected. They both have utc datestamp as a column.

       

      I want to see rejected / placed for each day, so I would like to join it on DATE([datestamp1]) = DATE([datestamp2])

       

      however we can't edit joins in the table? Any ideas?