Why are some dates not the same in Analytics as Alma?

Question

In Alma, the item Due Back Date field shows slightly different values in Analytics. Why are these dates not the same in Analytics?

Answer

Date functions such as CURRENT_DATE or CURRENT_TIME, which are determined by the system in which the Oracle server is running, are displayed in UTC (Coordinated Universal Time) also known as GMT (Greenwich Mean Time).

Date fields in reports within subject areas (for example, Loan Date in the Fulfillment subject area or Portfolio Creation Date from the E-Inventory subject area), which are determined by customer data, display the time at your institution.

• Article last edited: 02-Apr-2020