[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1140
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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