Month / Day Date

G

GCS Chuck

I know enough about Access to be dangerous; I need to enter the month and day
only in a field (change the default). I have been trying for 1 and 1/2 hours;
getting nowhere. Please help me! Thanks!
 
R

Rick Brandt

GCS said:
I know enough about Access to be dangerous; I need to enter the month
and day only in a field (change the default). I have been trying for
1 and 1/2 hours; getting nowhere. Please help me! Thanks!
Click to expand...

Are you saying you can't enter just the month and day or that the result
afterwards is not what you want? If the latter what is the result you get
and what is the result you want? As far as I know Access will assume the
current year if you don't provide one.
 
J

John Vinson

On Fri, 24 Jun 2005 10:51:05 -0700, GCS Chuck <GCS
I know enough about Access to be dangerous; I need to enter the month and day
only in a field (change the default). I have been trying for 1 and 1/2 hours;
getting nowhere. Please help me! 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 since midnight, December 30, 1899. As
such, any date/time value corresponds to an exact moment in time. If
you want to store June 24 without any year associated with it, that is
NOT a date/time value - there have been 105 June 24'ths since then and
will be many more.

Could you explain the business need? What are you trying to
accomplish?

John W. Vinson[MVP]
 
L

LeeLi

you may change yr date data type to mmdd from the particular date field.
right click on the fieid and you may see a column from the properties for
you to change the data type.
 
Top