ROUND({today}-{trandate}

Today is of date and time format while trandate is of date format only. You need to convert it first to date format using TO_DATE({today}).