I am making new inventory database. Eventually I will transfer the records from the old database into this new one.
One of the fields in the new one is "date received." Some of the old records only have the month and year, not day, month, and year. I have the short date input mask in right now, "99/99/0000;0;_." It won't let me just put "00" for the day.
How can I make the "day" part of the date optional? So, for instance, if the part was received in July of 2004, I could enter just the month and year and it would show up 07/2004, or 07/00/2004. Is this possible?
Another question relating to this is if it's possible to have "00" as the day, how would I make a query for say...all the days of that month, even when there is no day entered?
Thanks for any help you can give me.
One of the fields in the new one is "date received." Some of the old records only have the month and year, not day, month, and year. I have the short date input mask in right now, "99/99/0000;0;_." It won't let me just put "00" for the day.
How can I make the "day" part of the date optional? So, for instance, if the part was received in July of 2004, I could enter just the month and year and it would show up 07/2004, or 07/00/2004. Is this possible?
Another question relating to this is if it's possible to have "00" as the day, how would I make a query for say...all the days of that month, even when there is no day entered?
Thanks for any help you can give me.
