Date input field returns #Error

[lhanes72]

I have a report that produces a voucher. The user inputs the date and the date is printed on the form.

The field has =Format([What is the date that you want the check to cut?], "mm/dd/yyyy").

This worked fine January 31. February 3 when I tried to do it, instead of the date I got an #Error.

Does anybody know why this may have happened and/or how to fix it? Thanks

 

[KenHigg]

Maybe you need to use entries like 02/03/2009 instead of 2/3/2009 - ??

 

[lhanes72]

Thanks for the help. That worked!

 

[KenHigg]

Cool - You may want to look at a way to avoid this type error.