...
For all materials: account for Alma date variable quirks. Adjust queries to account for migration artifacts and inconsistent behavior for date variables due to Alma’s method of manipulating and storing date variables. For example, many Network Zone portfolios migrated with a null value for Activation Date.
For physical materials: use “Physical Items”.”Item Creation Date”
For electronic materials: use “Activation Date”
...