8 Replies Latest reply: Jan 21, 2014 7:52 PM by Ahyel Libunao RSS

    Can someone help me to do the script for the query below??



      Can someone help me to script the query below?


      I have 3 fields to use for this script.

      1. Document Number

      2. Approved Date

      3. Release Date


      Query: I wanted to get the month created (this could be approved date or release date). The problem is some of the rows of approved date are blanks. I wanted to get the released date insted for those blanks in approved date. How to do this script? Im not sure if if else statement would be fit for this.



      Thank you..