{today-60} or something according to Oracle SQL googling but can't get it working

Try {today}-60 instead. I think your formula isn't working because you have the curly bracket after 60.