fixed db date/time issues and finalized alerts