2 Replies Latest reply on Dec 7, 2017 10:13 AM by Tamisha Arthur

    Pivot fields  - Microsoft SQL

    Tamisha Arthur

      Hi Everyone,

       

      I know this is a topic which have been discussed but I need some help creating a custom SQL query to Pivot 2 fields.  So I have Open time & Close time date fields and I need to create one field which shows  a status of Open time or Close time and field which combines the actual date.

       

      Current Fields

       

       

      Need them to look like this