prepare datetime values for view indexing