I have recently migrated BOXI from one server to another server. Post migration, Reports are providing wrong data.
I am generating a report for number of incidents between 1st july and 31st july but it provides data for august 1st also.
I have checked the same in old BOXI server where it provides me correct data. please help me to fix this. Below is the query and report attached.
(in.resolve_date - in.open_date),
( (( in.open_date ) between @Prompt('Earliest Open Date', 'D', ,mono,free) AND @Prompt('Latest Open Date', 'D', ,mono,free) ) )