Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Input Mask

Discussion in 'Information Technology' started by Chi, Jul 28, 2006.

Tags:
  1. Chi

    Chi
    Expand Collapse
    Guest

    Hi,

    The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    the date/ month/year in the table.

    Would you show me what is the input mask if I wanted to enter the year only?


    Thanks
    Chi
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 11 Jul 2006 07:46:04 -0700, Chi wrote:

    > Hi,
    >
    > The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    > the date/ month/year in the table.
    >
    > Would you show me what is the input mask if I wanted to enter the year only?
    >
    > Thanks
    > Chi


    Sorry, a year is not a valid entry for a Date/Time datatype field.

    A valid date entry for a Date/Time field must include a month day and
    year.
    Access will guess (if you don't use an Input Mask) if you enter 1/5
    that you mean 1/5/2006 (the current year) or if you enter 7/2006 you
    mean 7/1/2006, but there is no way to simply enter 2006 as a valid
    date.

    If you only want the Year, than change the field datatype to Integer.

    Perhaps you should let us know why you want to do this, and someone
    will tell you how.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Chi

    Chi
    Expand Collapse
    Guest

    Thanks Fred,
    Your response is very helpful to me.

    Chi

    "fredg" wrote:

    > On Tue, 11 Jul 2006 07:46:04 -0700, Chi wrote:
    >
    > > Hi,
    > >
    > > The short date input mark is 99/99/0000;0; _. Therefore, I need to enter
    > > the date/ month/year in the table.
    > >
    > > Would you show me what is the input mask if I wanted to enter the year only?
    > >
    > > Thanks
    > > Chi

    >
    > Sorry, a year is not a valid entry for a Date/Time datatype field.
    >
    > A valid date entry for a Date/Time field must include a month day and
    > year.
    > Access will guess (if you don't use an Input Mask) if you enter 1/5
    > that you mean 1/5/2006 (the current year) or if you enter 7/2006 you
    > mean 7/1/2006, but there is no way to simply enter 2006 as a valid
    > date.
    >
    > If you only want the Year, than change the field datatype to Integer.
    >
    > Perhaps you should let us know why you want to do this, and someone
    > will tell you how.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page