extract part of date field

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

Guest

I have 2 date fileds - 1 is a serial date 2 is a date with time stamp.

I am rusty to Access 2000 and need to get a clean month in a filed and I
also need a month and yr in a filed.

My goal is to do cross tabs a summarize on these dates. My data sets are to
big to jump out to excel or I would be done.

Having trouble with expression builder and really don't know best way to go
about this.

thanks for time Todd
 
Hi,
Look up DatePart() function in help. You can extract the month or year from any date.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

expression off of date field 1
Date search query 0
Excel Help with dates 2
Convert Text To Valid Date 4
Updating tables when you input new data 0
Extracting only the Date part of a Date/Time field 5
Query to summarize/Count by month 3
Recordset Findfirst Date Issue 0

Back
Top