Access 2013 - need to convert date to quarter and year in the same column
Posted on 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: