Solved

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

Posted on 2015-01-26
2
776 Views
Last Modified: 2015-01-26
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
Comment
Question by:rnhturner1
  • 2
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 40570613
Quarter: DatePart("q",[created time]) &"/" & year([created time])
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 40570620
just change  &"/" & to whatever format you want.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now