3 Replies Latest reply on Apr 27, 2018 5:34 AM by Aditya Singh

# Quarter date conversion

I have a column titled "Quarter" and a column titled "Year". Both are string data types (Quarter = 01, 02, etc. and year = 2017) but I need to get these into a date format as "qq/yyyy". Any ideas?

• ###### 1. Re: Quarter date conversion

Hi, Heather

try this, create a calculation as below

Makedate(Int([Year]),

if [Quarter] = '01' then 1 elseif  [Quarter] = '02' then 4 elseif  [Quarter] = '03' then 7 elseif  [Quarter] = '04' then 10 end

,1)

and then drag it to row/column and format as qq/yyyy

ZZ

• ###### 2. Re: Quarter date conversion

Hi

you could try a case statement

It will return this

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

• ###### 3. Re: Quarter date conversion

You can use [Quarter] + "/" + [Year]. This will give you result as Q1/2018.