8 Replies Latest reply on Aug 14, 2012 11:35 AM by MarcMcCall

    Date Calculation - CurrentDate minus Due date

    SeanCusson

      Title

      Date Calculation - CurrentDate minus Due date

      Post

      I'm a very novice user. I understand FMP. I've watched the Lynda.com tutorial track. I've built (fairly successfully) a job tracking database for my department. What I can't figure out is how to show the remaining days of a project based on the Due Date (a popup calendar) and the CurrentDate. Currently I'm displaying the current date by using {{CurrentDate}} directly on the record. I figured that since it would never be a searchable field there was no reason to create it as one. I'm starting to doubt that now as I've seen mention of having to convert the date value somehow first. Being a novice, I don't quite understand how to get that to work. This is what I'm trying to achieve:

       

      Due Date: August 16

      Days Remaining: 2