What is a good selection formula statement to select data from the previous work day? I am trying
{Sample.appdate} -1
but when it gets to the SQL query it timestamps both the "less than" and the "greater than" datetimes the same.
Example: (AppDetails.DateDetailDisposed > {ts '2008-07-13 00:00:00.00'} AND
AppDetails.DateDetailDisposed < {ts '2008-07-13 00:00:00.00'}
Note that both are 00:00:00:00 times..
The dates are both then ignored and data since time began starts coming up.
I don't want to use parameters since the request doesn't change (alway's yesterday's data)..
Seems like they'd have a PreviousDay function..maybe its just me.
Any help gratefully appreciated