1 2 Previous Next 17 Replies Latest reply on Apr 11, 2017 3:05 AM by praveen p

    Using TODAY() returns ALL if 0 rows retrieved from Database

    Ronak Shah

      Dear Friends...

      In our dashboard we are using TODAY() to display the current date in the worksheet title, a common requirement.

      There are times when there wont be any data to display from the database.

      The problem is that the function TODAY() returns the word "ALL" instead of the date the dashboard is refreshed.

       

      We expected the refresh date to be populated and this shouldn't have been dependent on the rows retrieved from the database.

       

      Expectation was this function to be independent of the database.

       

      Please suggest if anyone has bumped into this type of issue.

       

      Thanks in advance...

        1 2 Previous Next