However, I would like to constrain the data to just the previous day using function, instead of a specific date. When I use anything but the "ts" syntax, I get an error. Depending on the type of function I use, the error messages are:

"Expected lexical element not found: identifier". - This is when I constrain using GETDATE() - 1