AnsweredAssumed Answered

Date Calculation - CurrentDate minus Due date

Question asked by SeanCusson on Aug 14, 2012
Latest reply on Aug 14, 2012 by MarcMcCall

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

Outcomes