Filtering Date and Time record fields by year

Hi andrzejr3338 , 

If you first generate year start date time and year end date time based on the year as the input, you can apply "between" operator on date time field. 
You can refer the below code. 

a!localVariables(
  local!yearStartDateTime: datetime(ri!inputYear, 01, 01, 00, 00, 00, 00),
  local!yearEndDateTime: datetime(ri!inputYear, 12, 31, 23, 59, 59, 00),
  a!queryRecordType(
    recordType: 'recordType!{99b0bb09-e2c0-4f75-a70b-26f247e2d095}AA Vehicle',
    fields: a!aggregationFields(
      groupings: {
        a!grouping(
          field: 'recordType!{99b0bb09-e2c0-4f75-a70b-26f247e2d095}AA Vehicle.fields.{3f0958cd-8b0d-4071-afdf-fa0902a40002}createdOn',
          alias: "yearCreatedOn",
          interval: "YEAR"
        )
      },
      measures: {
        a!measure(
          function: "COUNT",
          field: 'recordType!{99b0bb09-e2c0-4f75-a70b-26f247e2d095}AA Vehicle.fields.{0d5995ff-5e2d-40ad-8ce7-1dc2ebe91919}vehicleId',
          alias: "count"
        )
      }
    ),
    filters: a!queryLogicalExpression(
      operator: "AND",
      filters: {
        a!queryFilter(
          field: 'recordType!{99b0bb09-e2c0-4f75-a70b-26f247e2d095}AA Vehicle.fields.{3f0958cd-8b0d-4071-afdf-fa0902a40002}createdOn',
          operator: "between",
          value: {
            local!yearStartDateTime,
            local!yearEndDateTime
          }
        )
      },
      ignoreFiltersWithEmptyValues: true
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 100)
  ).data
)

This is not SQL code. You cannot apply a function to a field before it is evaluated in a filter.

andrzejr3338 said:

a!queryFilter(
field: datetext('recordType!{99b0bb09-e2c0-4f75-a70b-26f247e2d095}AA Vehicle.fields.{3f0958cd-8b0d-4071-afdf-fa0902a40002}createdOn',"MM/DD/YYYY"),
operator: "=",
value: ri!inputYear
)

Some options:

- use "between" as already pointed out (https://docs.appian.com/suite/help/23.4/fnc_system_a_queryfilter.html#return-cases-created-this-year)

- create a custom record field to extract just the year from the date und is it for your query

I assume you are working on the records. The best way to do so is to create a custom record field where you extract the year in a separate column and then filter on that column in your queryRecordType

Yes, you are right, year(rv!record['recordType!.CreatedDate']). This will work.