ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: Digitalsoft on July 13, 2021, 03:14:46 pm

Title: date selected from datepicker in format dd/mm/yy not binding in the grid
Post by: Digitalsoft on July 13, 2021, 03:14:46 pm

Hi Paramquery,
I have a column which is of type date  & it is editable, we initialized the column editor as per in the documentation, just provided the format as "dd/mm/yy" for the column as well as "dateFormat" attribute in the datepicker, The issue here is i can select a date from the datepicker but when focus out the editor the selected date is not binding in the grid cell. I have put the value in the console, it is "undefined". Please find the attachements for better clarity.

Title: Re: date selected from datepicker in format dd/mm/yy not binding in the grid
Post by: Digitalsoft on October 06, 2021, 09:06:00 pm

Hi Paramquery, any update on this issue?

Title: Re: date selected from datepicker in format dd/mm/yy not binding in the grid
Post by: paramvir on October 07, 2021, 10:01:10 am

Please check this example: https://paramquery.com/pro/demos/editing_custom format: 'dd/mm/yy' can be used for OrderDate column.

Point to be noted is that editor.getData has to be implemented to convert from column format into native js 'mm/dd/yy' format.

Code: [Select]

editor: {
     type: 'textbox',
     init: dateEditor,
     getData: function (ui) {
         //convert from column format to native js date format "mm/dd/yy"
         var dt = $.datepicker.parseDate(ui.column.format, ui.$cell.find("input").val());
         return $.datepicker.formatDate("mm/dd/yy", dt);
     }
 },