A date field less the year?

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

Alp Bekisoglu

Hi Experts,

Is it possible to get a date field without the year part? I would be using
this for an annual event thus I don't want any particular year to be
associated with it.

I think Miss Fischer once responded to a similar question but her response
is wiped off the NG.

Wouldn't it be nice to have a "Reply Repository" somewhere so the same
questions will not be asked over and over again? Well, just an idea...

Thanks in advance,

Alp
 
No. The Date/Time field must have a year.
Perhaps you could use two Number fields to store the day and month.
Or perhaps you could entering the starting date, and some mechanism to store
the frequency (yearly, monthly, ...).

For the archive of newsgroup posts, go to groups.google.com, and perform the
Advanced search on groups comp.databases.ms-access and
microsoft.public.access.*
 
Alp Bekisoglu said:
Hi Experts,

Is it possible to get a date field without the year part? I would be using
this for an annual event thus I don't want any particular year to be
associated with it.
Click to expand...

You could store your dates in a date field in the normal way.
To ignore the year, you could extract the day and month using the Day and
Month functions.
To save the date, just use CDate(day & "/" & month & "/" & "00"), suitably
adjusted for
your default date format.

David
 
Alp said:
Hi Experts,

Is it possible to get a date field without the year part? I would be
using this for an annual event thus I don't want any particular year
to be associated with it.

I think Miss Fischer once responded to a similar question but her
response is wiped off the NG.

Wouldn't it be nice to have a "Reply Repository" somewhere so the same
questions will not be asked over and over again? Well, just an idea...

Thanks in advance,

Alp
Click to expand...

Unless you are going to us the date in some calculation, why use a date
at all. Just use XX/XX or Nov 23?
 
Thank you for your replys guys.
Allen: I actually have the two numeric fields I am using now dut thought it
would/could be better if there was an option. BTW, I did search the
news.microsoft.com, found the one that Cheryl responded but it was no longer
on the server.
David & Joseph: I'll keep your suggestions in mind and give a try and see.

Thanks again.

Alp
 
Alp Bekisoglu said:
Hi Experts,

Is it possible to get a date field without the year part? I would be using
this for an annual event thus I don't want any particular year to be
associated with it.

I think Miss Fischer once responded to a similar question but her response
is wiped off the NG.

Wouldn't it be nice to have a "Reply Repository" somewhere so the same
questions will not be asked over and over again? Well, just an idea...

Thanks in advance,
Click to expand...

A date field contains the full date.

If you don't used an edit mask you can enter the date in a wide variety of
ways.
7 12 will be stored as 7/12/2004
The format determines how it is displayed.
So if you format it to show month and day if you entered 7 12 it would
display Jul 12 or July 12 or ....

If you need to pick dates and ignore years then add a calculated field to a
query which formats the display to what you want or use DatePart.

The advantages of using a date field almost always override problems such as
this. A text field would be quite happy with 13/0 when you wanted 1/30
 
Back
Top