Author Topic: Date Datatype not converting json date to date format  (Read 1681 times)

sam.shah

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 13
    • View Profile
Date Datatype not converting json date to date format
« 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

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Date Datatype not converting json date to date format
« Reply #1 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