Working with dates and times

Using standard functionality -

  1. issue the lot of material to the job - lets say 500 ounces
    do your processing
  2. return the lot of material from the job to stock - lets say 300 ounces.

The parttran table will capture both the date and time and who did the transaction.
It will also capture the jobs that used the material.

Now comes the magic that @Banderson could answer.
On the part table put in the expire time in hours as an attribute.
Create a dashboard that tracks the usage and cumulative total time of the lot based on the partTran table.
Check out his example using the PartTran table.