{OEORDH.ORDDATE} = tonumber(tostring({datefield},"yyyyMMdd"))

or use the datediff() function.  

something like if datediff("d", pwformatdate(ORDDATE),CurrentDate)=1   then xxx else xxx

Note that using pwformatdate() in a record retrieval is very inefficient, because Crystal has to retrieve all the records before evaluating the function.  Therefore, never do a selection criteria as

pwformatdate({OEORDH.ORDDATE}) in {dateparm1} to {dateparm2}

do it as

{OEORDH.ORDDATE} in tonumber(tostring({dateparm1},"yyyyMMdd")) to tonumber(tostring({dateparm2},"yyyyMMdd"))

and then Crystal will send the correct SQL query and retrieve much fewer records.  The difference in speed on large databases can be over 1000 to 1.

Note that using pwformatdate() in a record retrieval is very inefficient, because Crystal has to retrieve all the records before evaluating the function.  Therefore, never do a selection criteria as

pwformatdate({OEORDH.ORDDATE}) in {dateparm1} to {dateparm2}

do it as

{OEORDH.ORDDATE} in tonumber(tostring({dateparm1},"yyyyMMdd")) to tonumber(tostring({dateparm2},"yyyyMMdd"))

and then Crystal will send the correct SQL query and retrieve much fewer records.  The difference in speed on large databases can be over 1000 to 1.

Thank you kindly gentlemen