Yes, you can use the WHERE clause in a sp_report like this:

sp_report SalesByItemDetail show Text, Blank, TxnType, Date, RefNumber,
Memo, Name, Quantity, UnitPrice, Amount, RunningBalance, AccountFullName
parameters DateMacro = 'ThisYearToDate'
where AccountFullName='Hardware:Doorknobs Std' or AccountFullName='Appliance'

Hi, I tried filtering by a ModifiedTime time stamp according to this post. The statement is: sp_report SalesByItemDetail show Account, TxnType, Date, RefNumber, Item, Memo, Name, Quantity, UnitPrice, Amount, ModifiedTime WHERE "ModifiedTime" >= {ts '2006-11-20 00:00:00.000'}

However, I either get the error "invalid operand for operator >=" with the above syntax. Or when I try to change the time stamp format, I get "expected lexical element not found: <identifier>"

What is the correct format/syntax that needs to be applied? Your help is appreciated as always.

The ModifiedTime value is currently being returned as an invalid format in SP_REPORT that isn't useable in SQL comparsions etc.

ModifiedTime is returned as: 09/25/2002 11:54:25 instead of the normal SQL timestamp format as: 2002-09-25 11:54:25

I have requested this to be corrected by the QODBC Software Engineer on Ticket ID: BR00000041. Once the format is corrected you could do:

sp_report SalesByItemDetail show Account, TxnType, Date, RefNumber, Item, Memo,
Name, Quantity, UnitPrice, Amount, ModifiedTime
WHERE {fn CONVERT(ModifiedTime, SQL_TYPE_TIMESTAMP)} >= {ts '2006-11-20 00:00:00.000'}

in the meantime, you will need to use the Date (not as good):

sp_report SalesByItemDetail show Account, TxnType, Date, RefNumber, Item, Memo,
Name, Quantity, UnitPrice, Amount, ModifiedTime
WHERE Date >= {d '2006-11-20'}