Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Year only in date Field (XP/2K)

    I have a date field for entering a birthday. Is there a way that I can only enter a year of Birth and still keep it a date field?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Year only in date Field (XP/2K)

    No - if you store it as a date field, it requires that you have a day and a month as well as the year. Actually dates are stored as the number of days since 31/12/1899 as the integer portion of the value, and the time as the decimal portion on the value - and are stored as an 8 byte value. If you want to store just the year, then you need to store it as an integer.
    Wendell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •