Skip to Content
0
Former Member
Jul 17, 2008 at 05:01 PM

Data from Yesterday

89 Views

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