Convert date

[SBBmaster09]

Is there any ways that can convert Date:

In the form, the text field will always accept a format which is DD-MM-YYYY then when it is saved in the Table the output should be converted to MM/DD/YY Or M/D/YYYY. Disregarding that 04-07-2013 should be 7/4/2013 and not 4/7/2013.

Is that possible?? Thanks.

 

[RuralGuy]

This link should give you a better understand as to how DateTime fields are actually stored: http://support.microsoft.com/kb/q130514/en-us
What you are describing is just a display function and it can be displayed any way you want.