I have a macro that first sends and email with data from a form. Then I have in the macro to setvalue of a text box to the current date which the value is set to =date(). the value that appears in the form is 12/30/1899.