• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1432
  • Last Modified:

Access 2013 - need to convert date to quarter and year in the same column

I am using access 2013 and I have a date column (12/26/2014) and I want to run a query where I make another column that will show as the fourth quarter of 2014.

I am currently using:

 Quarter: DatePart("q",[created time])

But I need it show the year on it as well and I am not sure how to add that.

I am not too concerned how it is formatted as long as I can see that it is the 4th quarter of a particular year.

Maybe something like:

4:2014
or 4/2014
or 4,2014

Thanks,
Richard
0
rnhturner1
Asked:
rnhturner1
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
Quarter: DatePart("q",[created time]) &"/" & year([created time])
0
 
Rey Obrero (Capricorn1)Commented:
just change  &"/" & to whatever format you want.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now