In Tableau, you can create a calculated in the date format using the Qtr field as a basis. Here's one calculation that gets you there, by doing some string manipulation to generate 1/1/2011 for Q1, 4/1/2011 for Q2, etc.

DATE(STR(INT(MID([Qtr],2,1))*3-2) + "/1/" + RIGHT([Qtr],4))

Jonathan

Jonathan, it took me a minute to get the 3-2. Nifty bit of math.

--Shawn

@Shawn - Thanks! Too much messing around with telecoms billing data in my misspent youth is responsible for that one.

@Matt - You're welcome, and I agree that letting Tableau do the work for dates is very often easier (and faster, too).