Sage 100

Have what I thought was a simple request to filter AR invoices with yesterdays date in Sage Intelligence. Tried using a sql expression in the container and none of the expressions work except one that brings in the date and time but filter fails since Sage invoice date does not have the time on it. Tried to cast, convert date/time to date and cannot get anything to work. Open to suggestions.

Thank you.

------------------------------
Dana Halpin
Vrakas/Blum Computer Consulting, Inc.
------------------------------

You can use the report manager and put a parameter on the report. When you create it, you pick the Filter field you want (invoice date). It would take the date without the time.

------------------------------
Todd Martin
MBA Business Software
https://www.mbabsi.com
------------------------------