How do I format a date?

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

Guest

In designing a table record to return a date, but only the month/day, how do
I do that? Do I enter it under format or input mask and what do I enter?
 
To further clarify: I want to keep track of members' birthdates but I don't
need to know the year.
 
Internally, the date/time field is stored as a number. (It's the number of
days since Dec 30, 1899.) Therefore you cannot enter a value which has no
year.

The alternative is probably to use 2 Number fields: one of the month
(validation rule of Between 1 and 12), and another for the day.
 
Back
Top