Dear List: Access 2003 - VBA Is there a function that will convert a date in a text box formatted ddd d-mmm-yyyy (Fri 12-JUN-2015) to short date (mm/dd/yyyy) format? MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin