AnsweredAssumed Answered

Creating a separate field to show the most current Date in a table of Notes

Question asked by vlight on Feb 21, 2013
Latest reply on Feb 21, 2013 by vlight

Title

Creating a separate field to show the most current Date in a table of Notes

Post

     In FM Pro 11, I'm trying to find the right "calculation" to use on a field "MostCurrentAccurateDate."

     I have a table of Notes.  It includes 3 date fields:  

     1) "DateNoteCreated,"  an auto-entered field;  

     2) "DateActuallyOccurred" field -- where the user can enter a more appropriate date if needed  (e.g., notes about a conversation that was actually held on May 3rd, as opposed to the date in #1 above,  which would be the date the user actually gets around to creating that note in the database, say May 15th);  and

     3) "DateMostAccurate" -- a calculated field (result=Date) that gives me the value of #2 unless it's empty, in which case it defaults to give me #1.  

     I want to create one more field -- that could be shown on other layouts (in related tables) -- that will show me the date of  "the most recent" note, based on #3 above (the "dateMostAccurate").  How do I accomplish this??

Outcomes