Thank you, Andrew, for your help. I fixed the date format by changing the text CC to date picker CC. Is there a way to make the "Due Date" field un-editable? I know I change the field property to make to prevent editing but If I do that, the macro will not work since the form the protected.