Transaction date in order inquiry navigation does not match in comestri-tlogs staging instance in the internal network. Upon investigation, there was a deprecated function of MySQL version 8 using 'DATE_FORMAT' resulted to null values in transaction date. we adjust the date using Javascript date format instead of MySQL date format.