the best bet is to test separate parts of the formula in isolation, to see what is giving the error. MAke sure SYSDATE or {today} works by itself, for example. Then, wrap it in Trunc() and test again. Build the formula up slowly, in pieces, and you will at least find out which part is erroring out.