I have a column called 'Entry Date'. These dates take on the format of "1/2/2012" which translated to Jan 2, 2012. For some reason I though PP converted dates like excel did...
Anyways, here is what I have:
if entrydate rlike '%jan%'then
quarter := q1;
end if
I am trying to start simple, but evovle it in such a way so that I can eventually have it so Jan-March is Q1, Apr-Jun is Q2, Jul-Sep is Q3, and Oct-Dec is Q4.
Seeing as you cant have something start with a number this make it a little more difficult...
Any takers?
Changed it to this and nothing in the quarter tab:
rename('entry date', 'entrydate');
resize(quarter,0);
if entrydate rlike '1%' then
quarter := q1;
end if