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

    Time left on contract field

    Harris Dupre



      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.