3 Replies Latest reply: Oct 6, 2016 1:58 PM by Ian Sutherland RSS

    How can I calculate the age (in days) of a record given I have the creation date.

    Ian Sutherland

      There is no "Date difference" (DateSub) function.

      Using Date# does not work (If there is a difference between Date and Date#, I can not see it).

      Using Today(1)-Num(Date(CreateDate)) {or Today(1)-Num#(Date#(CreateDate)) } does not work.

      adding in Floor, etc. does not help.

      It always shows as "-".

       

      It seems as if CreateDate (which as a date hence a dual) will always be a date and so can not be subtracted from today.

       

      There is networkdays (read as net work days) that does sort of what I want except I want to count weekend days also.