front end filter

[Chinnu3]

I Have data as 

I need a filter in front end like which i select i need to see the data last 24hrs from yesterday 11pm to today 11pm. when ever i select this filter it should show yesterday's 11pm onwards today 11pm only.

If today date and time is 15-11-2021 11:30:20pm, If I select that filter it should show below data.

[vinieme12]

create  a new field in your script and offset to date+1 if hour>= 11

Date(floor(Report_Date) + if(Hour(Report_Date)>=11,1,0)) as new_Report_Date,