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