Never mind I finally worked out the cause over half of the old reports had words in the date column as soon as i removed them the dates are showing correctly now. Thankyou to anyone who tried to look into this.