Seal Report Forum
»
Report Edition
»
Reports
»
my sql between dates not working fine
Rank: Member
Groups: Registered
Joined: 10/31/2016(UTC) Posts: 13  Location: hyd
|
Dear Admin, Please find below error image attached link i selected 02-Nov-2016 but it showing 02-1111-2016 and if i selected between dates filter is not working it is showing all data currently i am using mysql database please advice me how to fix issue and my database date format is dd-mm-yy (23-11-16) https://goo.gl/photos/E7987SYY5PfbTCC6AThanks Edited by user Wednesday, November 23, 2016 7:41:34 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Hi, the between is a bug fixed in the incoming release 3.0: 69: Between operator may not work on MS Access or MySQL. You can have a pre release in http://sealreport.org/sealsetupbeta30.exeConcerning the date picker, it is a standard JQuery Picker, the format is given by the following code in the main Report.cshtml template: Code: var dateFormat = '@(View.CultureInfo.DateTimeFormat.ShortDatePattern.Replace("M", "m").Replace("yy", "y"))';
So it might depends on your culture Then this variable is used in common.js to init the picker: Code: //datepicker
$(".datepicker").datepicker({ constrainInput: false });
if (languageName.indexOf("French") == 0) $.datepicker.setDefaults($.datepicker.regional['fr']);
else if (languageName.indexOf("German") == 0) $.datepicker.setDefaults($.datepicker.regional['de']);
else if (languageName.indexOf("Spanish") == 0) $.datepicker.setDefaults($.datepicker.regional['es']);
else if (languageName.indexOf("Italian") == 0) $.datepicker.setDefaults($.datepicker.regional['it']);
else if (languageName.indexOf("English") == 0 && !isUSdate) $.datepicker.setDefaults($.datepicker.regional['en']);
else $.datepicker.setDefaults($.datepicker.regional['']);
$.datepicker.setDefaults({ dateFormat: dateFormat });
which uses the settings defined in datepicker.jsIt should be not difficult to fix this for your culture...
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
my sql between dates not working fine
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
