iamwiz82
IS-IT--Management
- Feb 12, 2002
- 27
I'm creating a database of future business(including OEM, size, dates, etc.) for my company and one of the fields is Vehicle SOP(start of production) date. This date should be a date in mm/yy format. In access 2000, i set it up so the table is formatted to mm/yy and in the input mask, i set up 00\/00;0;; for the required inputs.
My problem is this:
when i go into the table and view the SOP dates, they are not correct. Each date is mm/02(no matter what, all 2002). When i click on each one, i get a more detailed date, which is mm/(the year i set it up for)/2002. So if i enter 07/04 for one, it now reads 7/4/2002(notice the lack of 2 digits in the month and day). How can i fix this?
My problem is this:
when i go into the table and view the SOP dates, they are not correct. Each date is mm/02(no matter what, all 2002). When i click on each one, i get a more detailed date, which is mm/(the year i set it up for)/2002. So if i enter 07/04 for one, it now reads 7/4/2002(notice the lack of 2 digits in the month and day). How can i fix this?
