To filter date in expression rule

Yes it is possible you can apply the selection the particular column and use >= and <= to fetch the data between two dates and concat them using to string.

Your query will be like this

  a!queryEntity_22r2(
    entity: cons!AA_VEHICLES_DSE_POINTER,

    query: a!query(
      selection: a!querySelection(
        columns: a!queryColumn(
          field: "vehicleDateAdded"
        )
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {

          a!queryFilter(
            field: "vehicleDateAdded",/*field Name*/
            operator: ">=",
            value: ri!startDate
          ),
          a!queryFilter(
            field: "vehicleDateAdded",/*field Name*/
            operator: "<=",
            value: ri!endDate
          )
        },
        ignoreFiltersWithEmptyValues: true
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 10
      )
    ),
    fetchTotalCount: false
  ).data

Yes it is possible you can apply the selection the particular column and use >= and <= to fetch the data between two dates and concat them using to string.

Your query will be like this

  a!queryEntity_22r2(
    entity: cons!AA_VEHICLES_DSE_POINTER,

    query: a!query(
      selection: a!querySelection(
        columns: a!queryColumn(
          field: "vehicleDateAdded"
        )
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {

          a!queryFilter(
            field: "vehicleDateAdded",/*field Name*/
            operator: ">=",
            value: ri!startDate
          ),
          a!queryFilter(
            field: "vehicleDateAdded",/*field Name*/
            operator: "<=",
            value: ri!endDate
          )
        },
        ignoreFiltersWithEmptyValues: true
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: 10
      )
    ),
    fetchTotalCount: false
  ).data

Thank you. But I am facing this below error,

a!queryFilter(
    field: "parIncludedPeriods_txt",/*field Name*/
    operator: "includes",
    value: concat(text(local!date1,"mm.dd.yyyy")," to ",text(local!date2,"mm.dd.yyyy"))
  )

Change the variables date1 and date2 with your original onces. 

 I tried now. This works fine. Many thanks Harshit !!

Great. Please take a moment to verify the answer so people can easily find the solution if they face the same problem. 

Done. Thanks.