Thanks for your response Paul. that was a typo on my part, as i had to type the code in the forum, i couldn't copy the text out of the word for some reason. So I do have the space, and the format still isn't working, so i am not sure where the issue lies as the date format shows correctly if the field is outside of the if statement. I will just have the staff update that one date manually until i can figure this out.

Thanks again for your assistance.
Sean