I'm thinking something like "ROUND(TO_DATE('12/31/2014', 'mm/dd/yyyy')-{datecreated})" might do it although that doesn't account for time.