Convert dd-mm-YYYY to Quarter

  • Thread starter Thread starter kza40381
  • Start date Start date
K

kza40381

Can someone help me convert my date field i.e. "6/26/2003" to quarters of the
year using vb code? Thank you!
 
Format([YourDateField],"yyyy-q")

or
DatePart("q",[YourDateField]) as TheQuarter
and
Year([YourDateField} as TheYear

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Consider using the DatePart Function:

DatePart("q",[name of Date field])

Good Luck.
 
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

Count records added in current week 3
basMedian obtaining quarterly results 5
How to enter a date in DD-MM-YYYY format 2
convert date 1
Forcing a date entry format of dd/mm/yyyy 1
Change format to mm dd yyyy hh mm ss 1
SQL statement with dates/times 2
How to convert mm/dd/yyyy date format to yyyy-mm-dd 3

Back
Top