Number of days in Inventory
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?