Turns out I did that same thing when I first tried it... You have to wrap the units in double quotes, because this is .NET, not SQL (so the rules are slightly different):

=DateAdd("d",-1,MAX(Fields!TransDate.Value, "BankBalance"))