1 Reply Latest reply on May 27, 2016 8:45 AM by Mahfooj Khan

    Time left on contract field

    Harris Dupre

      Hi,

       

      I'm trying to create a table that has the time left on a customer's contract in the final field.

       

      Currently the columns are customer ID, customer name, and customer contract numbers.

       

      I added a calculated field that used the function DATEDIFF('day',[END_DATE],date(today()),'sunday').

       

      This returned a number (how many days left on contract) but was adding a small graph to the end of my worksheet, instead of just an integer next to the contract number.

       

      I then added another calculated field dividing my original calculation by 365, so that I could have the years.

       

      Again, this worked but is giving me a graph in that column. I just want the integer, which I can see when I hover over the graph, not a graph within my sheet.

       

      Thanks