filter values according to date from date and time field

Hi,

This might help you, but please do test it out thoroughly:

a!queryLogicalExpression(
  operator: "AND",
  filters: {
    a!queryFilter(
      field: "bookingDate",
      operator: ">=",
      value: todatetime(today())
    ),
    a!queryFilter(
      field: "bookingDate",
      operator: "<",
      value: todatetime(today() + 1)
    )
  }
)

Thank you for your reply. I actually tried in this way but it give me the data only for today, but i want like:  whichever date I click/select i need to get that day all booking details

Yes, instead of today() function, if you pass your respective variable, it will work as expected.

No , it is actually showing me complete data , it is not showing me according to a particular date 

Can you post screenshots / examples of what you did? The post by Selvakumar should work for what you need.

Just to add, my preference to convert date values to datetime for this type of scenario is with fn!datetime(), as todatetime() applies a timezone offset:

a!localVariables(
  local!bookingDate: today(),
  local!pagingInfo: a!pagingInfo(1,-1),
  
  a!queryEntity(
    entity: cons!YOUR_DSE,
    query: a!query(
      paginginfo: local!pagingInfo,
      logicalexpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(
            field: "bookingDate",
            operator: ">=",
            value: datetime(
              year(local!bookingDate),
              month(local!bookingDate),
              day(local!bookingDate),
              0,
              0,
              0
            )
          ),
          a!queryFilter(
            field: "bookingDate",
            operator: "<",
            value: datetime(
              year(local!bookingDate),
              month(local!bookingDate),
              day(local!bookingDate)+1,
              0,
              0,
              0
            )
          )
        }
      )
    )
  )
)

I am getting all the 55 items when I select a date 

What is the operator in your logical expression? Can you please paste the whole code using the Insert code option?

a!localVariables(
  a!queryEntity(
    entity: cons!PO_MEDICALINFO,
    query: a!query(
      aggregation: a!queryAggregation(
        aggregationColumns: {
          a!queryAggregationColumn(
            field: "reportingDoctor",
            isGrouping: true
          ),

          a!queryAggregationColumn(
            field: "patientId",
            alias:"patientCount",
            aggregationFunction:"COUNT"

          ),
          a!queryAggregationColumn(
            field: "reasonForVisit",
            isGrouping: true
          ),
          a!queryAggregationColumn(
            field: "appointmentDate",
            isGrouping: true
          )

        }

      ),
      logicalexpression: a!queryLogicalExpression(
        operator: "AND",
        filters:  {
          a!queryFilter(
            field: "reasonForVisit", 
            operator: "=",
            value:ri!reasonForVisit,
            
          ),
         
              a!queryFilter(
                field: "appointmentDate",
                operator: ">=",
                value: todatetime((ri!appointmentDate))
              ),
              a!queryFilter(
                field: "appointmentDate",
                operator: "<",
                value: todatetime(ri!appointmentDate + 1)
              ),
         
         
          
          
          a!queryFilter(
            field: "reportingDoctor",
            operator: "=",
            value:ri!reportingDoctor
          ),
        },
        ignorefilterswithemptyvalues: true()

      ),
    pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: -1
      )
    ),
    fetchTotalCount: true
  ).data,
   
    
 
      )

AND Operator is used in my logical expression