We've already advised that it's best you use a form to capture data instead of an inputbox.
In any case, use one of these:
In any case, use one of these:
Code:
Format(InputBox("tot: dd-mm-yy", "End Date"), "\#mm\/dd\/yyyy\#")
Format(InputBox("tot: dd-mm-yy", "End Date"), "mm/dd/yyyy")