I have a field in a cell which is a DOB field. the format is Date/Time. The
data appears like this MM/DD/YYYY. I need to split it up in three fields,
Field 1=MM, Field 2=DD, and Field 3=YYYY. How would I do that?
If the field is a data time field and all you want to do is display
the month, day or year, all you need do is format the control.
Set the Control's Format property to
yyyy for the year,
mm for the 2 digit moth, or
dd for a 2 digit day.
There is really no good reason that I can think of to store 3
different parts of a date.
If you needed to get a list of birthdays for the current month, for
example, all you need do is use something like this in a query.
Select [FirstName] & " " & [LastName] as FullName, YourTable.[DOB]
from YourTable
Where Format(DOB],"mm") = Format(Date(),"mm")