4 Replies Latest reply: Apr 14, 2011 2:37 PM by Rob Wunderlich RSS

    New calculated time field

    Gerhard Laubscher

      Hi,

      I am loading a table with the following two fields:

      1. Date of last payment
      2. Date of last purchase

      I would like to create an additional field called "Days since last movement".

      This must look at whatever is the latest date of the two above-mentioned fields, and then subtract that from TODAY's date.

      Example:

      • Date of last payment - 2011/04/10
      • Date of last purchase - 2011/04/01
      • Days since last movement = 4

      Possible?

      Gerhard