8 Replies Latest reply on Jul 15, 2015 10:12 AM by schamblee

    Date - GetNthRecord ( Date ; Get ( RecordNumber ) - 1 )

    ucharles

      I used the GetNthRecord to calculate the duration of days for water consumption. The formula works fine in so far as it getting me the difference between the current date and previous date (which GetnthRecord gets but only as number). The current-date = Date or the current on my computer: thats obvious and available. GetNthRecord ( Date ; Get ( RecordNumber ) - 1, which gets me the value of the previous date a number. But how do I turn that number into back into a date (like 02/04/2015)?