1

The search field in jqGrid doesn’t return the date 20-03-2020. For other dates it's OK, but this date is not being returned. Why?

{
  colModel:[{ 
    name:'data_reg', 
    index:'data_reg', 
    align:"center",
    editable:false, 
    formatter:'date',
    formatoptions:{newformat:'d-m-Y'},
    width:10
  }]
}
Jeremy Caney
  • 7,102
  • 69
  • 48
  • 77
Rino
  • 11
  • 1
  • Are you certain it’s just this date? And not any date where, for instance, the day is over 12? The reason I ask is that it may not be recognizing the `formatoptions` and thus searching it as an American style `m-d-Y`, in which case `20-03-2020` wouldn’t show up as a valid date—but, in that case, neither would e.g. `13-02-2020`. Alternatively, are you certain that the `m` in `formatoptions` accommodates leading zeroes? In other words, does it find `20-3-2020`? Some format strings differentiate between e.g. `d` and `dd`, though conventions vary. – Jeremy Caney Apr 01 '20 at 08:59
  • thanks for the reply, I tried to delete the formatoptions function too, but it doesn't work. it is only that date the others work. – Rino Apr 01 '20 at 11:03
  • Any example with live data will be greatly appreciated, otherwise I can't help. – Tony Tomov Apr 01 '20 at 19:40
  • do you want access to the software? – Rino Apr 02 '20 at 10:54

0 Answers0