Yes

DateCalc(@date,-1)

Only prob is the DateCalc() UDF returns YYYY/MM/DD.
_________________________
Give a man a fish and he will be back for more. Slap him with a fish and he will go away forever.