How to filter DateTime filed by date only

shamima0001, you will can cast your DB field from DateTime to just Date. Once you do that, you'll be comparing Dates with Dates. Check the todate() function for that

docs.appian.com/.../fnc_conversion_todate.html

Can you explain a bit more, I did not understand what you are trying to explain.

SAIL:

a!queryEntity(
  entity: cons!SUMMARY,
  query: a!query(
    logicalexpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "startdate",
          operator: "=",
          value:ri!startDate
        ),
        a!queryFilter(
          field: "enddate",
          operator: "=",
          value:ri!endDate
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    selection: a!querySelection(
      columns: {
        a!forEach(
          {
            "startdate",
            "enddate"
          },
          a!queryColumn(field: fv!item)
        )
      }
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: -1
    )
  ),
  fetchTotalCount: false
).data

Hi there. Sorry for that, I was picturing the opposite scenario. Feel free to take a look at the below post in Community.

community.appian.com/.../how-to-filter-date-using-query-entity

Hi,

Although, it does filter data based on date provided. However, there is a problem with this approach. Where we dont provide any value in date picker it give me an error (below).

A null parameter has been passed as parameter 1. 

SAIL

a!queryEntity(
  entity: cons!SUMMARY,
  query: a!query(
    logicalexpression: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: "startdate",
          operator: "=",
          value:{gmt(todate(ri!startDate)),gmt(todate(ri!startDate))+day()}
        ),
        a!queryFilter(
          field: "enddate",
          operator: "=",
          value:ri!endDate
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    selection: a!querySelection(
      columns: {
        a!forEach(
          {
            "startdate",
            "enddate"
          },
          a!queryColumn(field: fv!item)
        )
      }
    ),
    pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: -1
    )
  ),
  fetchTotalCount: false
).data

Two things I noticed:

1. I think you want to use the "between" operator on line 9 instead of "=".
2. The "ignoreFiltersWithEmptyValues" property isn't going to work quite right here because you're providing an expression as the value. I'd recommend instead using the "applyWhen" property to determine when to apply the filters. Something like this:

a!queryFilter(
  field: "startdate",
  operator: "between",
  value:{gmt(todate(ri!startDate)),gmt(todate(ri!startDate))+day()},
  applyWhen: not(isnull(ri!startDate))
)

Two things I noticed:

1. I think you want to use the "between" operator on line 9 instead of "=".
2. The "ignoreFiltersWithEmptyValues" property isn't going to work quite right here because you're providing an expression as the value. I'd recommend instead using the "applyWhen" property to determine when to apply the filters. Something like this:

a!queryFilter(
  field: "startdate",
  operator: "between",
  value:{gmt(todate(ri!startDate)),gmt(todate(ri!startDate))+day()},
  applyWhen: not(isnull(ri!startDate))
)