3 Replies Latest reply on Mar 31, 2011 8:37 AM by jd3

    Number of days in Inventory

    jd3

      Title

      Number of days in Inventory

      Post

      I have a calculation field that should calculate the number of days an item has been in inventory. I used the "get date" function and it works as long as I enter a new date, however is does not update when a new day rolls around so my data is not accurate when I open the file tomorrow. Am I using the wrong function or do I need to script something to update the records? If so, can you give me some help on the script?

      FileMaker_Days.JPG