fixing issue with date shifting in record