I want to run a gridview search that pulls all invoices for a certain date range and for transaction "IN" or "CN". How do I add and OR to the Trx Type to include "IN" or "CN"
AND(
{Trx Date} >= DATE(2018,01,01),
{Trx Date} <= DATE(2018,10,31),
{Trx Type} = "IN"
)

AND(
{Trx Date} >= DATE(2018,01,01)
,
{Trx Date} <= DATE(2018,10,31)
,
OR(
{Trx Type} = "IN"
,
{Trx Type} = "CN"
)
)

You should learn how the QUERYDATE function works so you don't have to hard-code the date range into the filter.

Steve

Thanks