Michele, I'm fairly certain Jonathan Drummey posted a solution similar to this about six months ago. He might be able to help you.

Hi Michele,

One way to do this is to create a calculated field similar to the following:

if left([Date], 1)='1' then date('1/1/20' + right([Date], 2))

elseif left([Date], 1)='2' then date('4/1/20' + right([Date], 2))

elseif left([Date], 1)='3' then date('7/1/20' + right([Date], 2))

elseif left([Date], 1)='4' then date('10/1/20' + right([Date], 2))

end

Then, if you'd like to change the format, right click on it and select Format. Under Dates, choose Custom and type in the following to get a similar output as what's in your data:

\Qq yyyy

Hope this helps!

-Tracy