@Noel B try using SysDate instead of {today}

Sorry, new to some of this stuff, would it be "{SysDate}" or "SysDate"

without the curly braces around it. it's an Oracle function that return the current datetime