The date time format used for building the SQL is defined in your Connection Data Source.
Select your Data Source, then Connection.

The other format is for the display format only.

yes, you are right, to have the DateTime Picker, you need to have a restriction of type DateTime
the html is built in 'Report.iRestrictions.partial.cshtml'

then the format is either Date or DateTime, it is set in common.js:
//Date Picker
$(".datepicker_datetime").datetimepicker({
showClose: true,
showClear: true,
format: shortDateTimeFormat,
});

$(".datepicker_date").datetimepicker({
showClose: true,
showClear: true,
format: shortDateFormat
});

So the format of the picker is not taken from your restriction...it could be an enhancement but might be complicated to handle all format.
you can change the DatePicker format in your Root View:
Additional JavaScript


But after, the validation of the date will not work...
So I added this point in the wish list (perhaps in 4.1)

Edited by user Wednesday, July 25, 2018 11:47:05 AM(UTC)  | Reason: Not specified

Actually, select your root View in the tree view.
Then edit the property 'Additional JavaScript'. This allow to insert JS in the result.

You can do that, it will work for the picker but it will not pass the validation on the server....so it won't work.

Hi,

I am trying a similar thing but not getting the results. I have put date in restriction and I want it to automatically set current date in restriction value. I need to get results of date when someone executes the report. Lets say if execute today the result should be for Aug 07, if execute tomorrow then result should be of date Aug 08. How it can be done?