I've written an expression to calculate revenue invoiced today using a variable but I can't seem to get the syntax correct. I keep getting error in set modifier ad hoc element list: ',' or ')' expected.
I figured out the issue. My TRANDATE field did not have the same date format as my vToday variable, so I just created a new TransDate field that has the same format. Now when I plug that field into the expression you gave me it is returning a value. Thank you for your help with the expression.