Using 14.2.20142.2140
I would like to change the default date format used within the Advanced Filter Dialog.
Currently it is showing the date with MM/DD/YYYY formatting I would like to use DD/MM/YYYY.
Haven't been able to spot any information in the online documentation.
Regards
Aidan
Hello Aidan,
Thank you for posting in our community.
By design the igFiltering input editors will take the format set for the corresponding column. What I can suggest is setting this property for the date column and this automatically use the same formatting for the editors. For example:
$("#grid1").igGrid({ autoGenerateColumns: false, autoCommit: true, columns: [ { headerText: "Product ID", key: "ProductID", dataType: "number", width: "200px" }, { headerText: "Product Name", key: "Name", dataType: "string", width: "200px" }, { headerText: "Product Number", key: "ProductNumber", dataType: "string", width: "200px" }, { headerText: "Standard Cost", key: "StandardCost", dataType: "number", width: "200px" }, { headerText: "Make flag", key: "MakeFlag", dataType: "bool", width: "200px" }, { headerText: "Sell Start Date", key: "SellStartDate", dataType: "date", width: "200px", format: "dd-MM-yy" } ], primaryKey: "ProductID", dataSource: adventureWorks, renderCheckboxes: true, features: [ { name: 'Filtering', mode : "advanced" }] });
$("#grid1").igGrid({ autoGenerateColumns: false, autoCommit: true, columns: [ { headerText: "Product ID", key: "ProductID", dataType: "number", width: "200px" }, { headerText: "Product Name", key: "Name", dataType: "string", width: "200px" }, { headerText: "Product Number", key: "ProductNumber", dataType: "string", width: "200px" }, { headerText: "Standard Cost", key: "StandardCost", dataType: "number", width: "200px" }, { headerText: "Make flag", key: "MakeFlag", dataType: "bool", width: "200px" }, { headerText: "Sell Start Date", key: "SellStartDate", dataType: "date", width: "200px", format: "dd-MM-yy" } ], primaryKey: "ProductID", dataSource: adventureWorks, renderCheckboxes: true, features: [ { name: 'Filtering', mode : "advanced"
}] });
I also made a small sample illustrating my suggestion and I am attaching it for your reference.
Please have a look at the sample and if you have any additional questions afterwards please feel free to contact me.
Please let me know if you need any further assistance with this matter.
Hi Vasya,
I have been unable to respond due to a delay in getting my license renewed.
I have tried your suggestion and unfortunately it still does not work.
I have tried with the latest version of your product 15.1.20151.1005 and the issue is there too.
Could you give me some guidance as to how to trouble shoot this issue.
I know it is been a while since you posted and I hope you was able to achieve your requirement using version 15.1. However, just in case that you still need assisatnce I am attaching a modified sample using version 15.1.
Please let me know if you have any additional questions regarding this matter.