ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: sam.shah on April 24, 2018, 09:55:54 am

Title: Date Datatype not converting json date to date format
Post by: sam.shah on April 24, 2018, 09:55:54 am

Hi,
 {
                    title: "Actual Start Time", width: 150, dataType: "date", align: "center", dataIndx: "ActualStartTime", format: 'yy-mm-dd',
                    editor: {
                        type: 'textbox',
                        init: dateEditor
                    }

                }
above code render date in JSON format, I mean like this. Date\1280635200000-0400\.
how can I get date format correctly?
Do I need to convert it manually?
Thanks

Title: Re: Date Datatype not converting json date to date format
Post by: paramvir on April 24, 2018, 09:58:09 am

date field values need to be in js natively recognized formats.

mm/dd/yyyy e.g., 07/04/1776

ISO 8601 format yyyy-mm-ddThh:mm:ss e.g., 1776-07-04T08:20:01

https://paramquery.com/pro/api#option-column-dataType