Date format does not work

[richardm55]

I wanted to asssign the field "Number of magazine" with special format based on date/time format but showing only year and month in the format: "yyyy-mm".
So in property of this field in format I put yyyy-mm and in input mask I type 0000-00;;-
I also created the form based on the table containing above field and I defined format and input mask for corresponding formant in the same way like at the table.
But if I try to type date for example 2014-01 in text box of the form it comes up with the full date 2014-01-01. Why does it do like this? What do I do incorrectly?

 

[jdraw]

Richard,

I suggest you use a naming convention that does not permit embedded spaces or special characters. You will save yourself a lot of syntax errors and time by doing so.

You'll also find if you use the 1 field 1 fact approach you'll improve your productivity. You certainly can concoct your own format with partially concatenated facts, but too much embedded intelligence in custom codes will cause you more trouble than you need. Can you do it --sure; should you do it-- depends on how much time you want to spend figuring out what others have experienced.

What's wrong with MagazineIssueYear, MagazineIssueMonth ...

Access wants the Dates in American format, you can display them anyway you want.

In the United States, dates are traditionally written in the "month day, year" order,

Good luck with your project.

 

[richardm55]

Thank you. Yes, I know I could put those informations year and month in two separate fields and maybe it is the easiest way to do that.