I have a serial date filed and a
date filed with a time stamp.
I need to get a clean month out
of one of these dates. Also I need
to get a clean month and date combined
out of one of these fileds.
Is this a Microsoft Access question about the default Jet database engine
databases? If so, please clarify. There's only one kind of date/time field
in the default Jet database -- no "serial date" nor "timestamp". To get a
month number from a date field, use
FORMAT ([thedatefield],"mm")
to get a month abbreviation
FORMAT ([thedatefield],"mmm")
to get a month full name
FORMAT ([thedatefield],"mmmm")
Month and day would use a format of
"mm/dd" or "mmm dd" or "mmmm dd"
respectively.
If you are talking about MS SQL Server databases, with Access as a client,
microsoft.public.access.adp.sqlserver would be a good newsgroup if you are
using an Access Project (ADP) or microsoft.public.access.odbcclientsvr if
you are using an Access Database (MDB/MDE) with tables linked via ODBC
drivers.
Larry Linson
Microsoft Access MVP
