AnsweredAssumed Answered

Number of days in Inventory

Question asked by jd3 on Mar 31, 2011
Latest reply on Mar 31, 2011 by 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

Outcomes