Hi, I have a database for holding orders that come to my company and along with other data it has to hold the date this order was from which gets typed in manually.
I made an input mask of: 99/99/00;0;_ to make the / / automatically come up so they wouldn't need to be typed in manually but i originally had the date format dd/mm/yy to show the days, months and years correctly but it kept switching them around for no reason. I've also tried changing it to short date and removing the format so it would stay as it was typed but it's still doing it and i don't know why.
if you typed 29th Oct 2004 it would change to 10/ 4/29.
how do i fix this?