Hello all,
I am new to access and am having a problem with the date picker. I'm using access 2007. All of my dates are bound, no inputmask, and the format is set to short date. Some of the dates have a smart tag linked to my outlook calendar. However when I select a date on the picker it changes from day-month-year to month-day-year depending on the date.
If the day is 1-12 it displays as day-month-year
If the day is higher than 12 it displays as month-day-year
I don't care which way the date is displayed, it just can't be both ways! Is there a way to fix this so that it is always displayed one way? If anyone could help with this I would appreciate it.