Wijmo Date format

Wijmo Date format

Posted by: parmarkinjalk on 11 March 2020, 10:32 pm EST

• 

  parmarkinjalk

  • Post Options:
  • Link
    Copy

  Posted 11 March 2020, 10:32 pm EST

  Hi Team,

  I have 2 questions regarding date.

  1. In my json response I am getting date as a string like this(2019-05-02T17:07:16) I want to display this in this format “15 Nov 2019 5:07 PM” in the grid. How do I do that.

  2. I am am using wj-input-date as below. when I check the value of startDate its showing it as “Wed Mar 11 2020 13:30:00 GMT-0400”. How can I change this to just get the value like “2020-3-11”.

  <wj-input-date [(value)]="startDate">
                        </wj-input-date>
  

  Thanks.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 12 March 2020, 2:10 am EST

  Hi Kinjalk,

  Since JSON stores the dates in string format, the FlexGrid does not know whether the particular data is a date or string. So, you will need to parse the data using the reviver callback of the JSON.parse method. Please refer to the demo sample below:

  https://www.grapecity.com/wijmo/demos/Core/CollectionView/LoadingData/LoadingJSONDates/angular

  Also, to display the date in a particular format, you can set the format property of the date column:

  https://www.grapecity.com/wijmo/api/classes/wijmo_grid.column.html#format

  In your case, the format should be ‘dd MMM yyyy H:mm tt’.

  Similarly for InputDate, you can set the format property to ‘yyyy-M-dd’:

  https://www.grapecity.com/wijmo/api/classes/wijmo_input.inputdate.html#format

  In Wijmo, the format property can be set according to the dot net formatting which you can read more about it from here:

  https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

  Let me know in case you have any doubts

  Regards,
  
  Ashwin