Date Format (Eg. 1/2/2012)

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