expression off of date field

T

Todd F.

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.

Thanks For your time
Todd
 
L

Larry Linson

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.
Click to expand...

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
 
Top