In report based on 'SQL with parameters' DateTime parameter requires value in mm/dd/yyyy (US) format instead of local date format.