Maintenance Notice: labkey.org will be offline at 10:00 AM Pacific Time on Sunday, July 14th 2024 for maintenance. The estimated downtime should be no more than one hour. Please save your work before this time. We apologize for any inconvenience.
All Sample Types have a built in system field for recording Expiration Dates. This information can be used to assist lab managers in managing materials in their lab by finding samples due to expire soon. In addition, tracking samples with low aliquot counts can help determine when additional supplies may need to be ordered.

Enable Expiration Date Field

When you define or edit a Sample Type, you will see the MaterialExpDate (Expiration Date) column listed with the Default System Fields.

Enable it by checking the box (it is enabled by default).

You can also check the box in the Required column to require that every Sample of this type have an expiration date. Note that if you have existing Samples without expiration dates, they must be populated before the field can be required.

Disable Expiration Date for a Sample Type

If you uncheck the box for this field, you and your users will not see, be able to set, or use Expiration Dates for this Sample Type. Note that if you use this field at first and it contains data, disabling it will not delete the data. If you later re-enable it, the previous data will be returned to view.

Assign Expiration Dates to Samples

When Samples are added or updated, either manually using a grid or via import from file, the Expiration Date can be supplied. In a file import, the column name should be MaterialExpDate.

Find Expired Samples or Samples About to Expire

Samples that have already expired are marked with an indicator in the UI. Look for a red triangle in the corner of the grid value or the storage cell location. You'll also see these indicators in the detail panel for a sample.

You can save ways to view expiring or expired samples by filtering or sorting grids by the Expiration Date column. You can save as a named grid to access later.

In addition, you can use the built in Sample Finder report to find Samples of all types with an Expiration Date value in the next week.

Edit this report if you want to change the time interval, such as to find samples expiring in the next month. You can save a revised report with a new name.

Related Topics

Was this content helpful?

Log in or register an account to provide feedback

expand allcollapse all