logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
irreddy123  
#1 Posted : Wednesday, November 23, 2016 7:39:42 AM(UTC)
irreddy123

Rank: Member

Groups: Registered
Joined: 10/31/2016(UTC)
Posts: 13
India
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/E7987SYY5PfbTCC6A

Thanks

Edited by user Wednesday, November 23, 2016 7:41:34 AM(UTC)  | Reason: Not specified

epf  
#2 Posted : Wednesday, November 23, 2016 8:34:04 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 922
Switzerland

Thanks: 14 times
Was thanked: 154 time(s) in 148 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.exe

Concerning 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.js

It should be not difficult to fix this for your culture...
Users browsing this topic
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.