Date 2004/2005

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have created a table and I have a field called PlannedDate. I have given
it a date/time data type and am trying to figure out how to display only the
year format in the field. I would only like the user to enter 2004/2005 and
have this saved as the date. In the field properties (format) I entered
yyyy"/"yyyy.
When I open the table it changes the year to the yyyy/mm/dd format. Do I
have to do something with the input mask?

I looked at the help files and they weren't very helpful.

Thanks..
 
2204 is not a date. Change the field to either text or number and format it
to 4 characters and only allow numbers to be entered.

You could also change the format to display only the year
Format([SomeField],"YYYY), but why store "January 1, 2004 00:00:00 when all
you want is a four-digit number?


Rick B
 
Hello,

I have created a table and I have a field called PlannedDate. I have given
it a date/time data type and am trying to figure out how to display only the
year format in the field. I would only like the user to enter 2004/2005 and
have this saved as the date. In the field properties (format) I entered
yyyy"/"yyyy.
When I open the table it changes the year to the yyyy/mm/dd format. Do I
have to do something with the input mask?

I looked at the help files and they weren't very helpful.

Thanks..
Click to expand...

An Access Date/Time value is stored as a double float number, a count
of days and fractions of a day (times) since midnight, December 30,
1899; the format used to display that value is irrelevant to what is
stored. As such, any value in a Date/Time field must correspond to an
exact moment in time - not to something as vague as you suggest.

You'll probably need to use a text field to store this information.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top