We have two date fields (start and end) in component Metadata. We are displaying all the components with a start date less than the current server time and an end date is greater than the current server time.
CustomMetaDateRangeCriteria("Startfieldname",Datetime.MinValue,servertime,true) Criteria.Add(new CustomMetaDateRangeCriteria("endfieldname",servertime,Datetime.MaxValue,false)
The above query works fine in the 8.5 environment but in 9.5, query results are not accurate. I guess it is not considering the "HH:mm:ss" while returning the results. I Checked custom_meta table and date value stored as it is in the Metadata field and it is not converted to UTC format.