[SysProfileParticipant]

I found an old post, same problem. http://www.jqwidgets.com/community/topic/jqxgrid-date-display-issue/, http://jsfiddle.net/sGGZ3/287/

[SysProfileParticipant]

I found an example of the Grid component (http://jsfiddle.net/jqwidgets/5YtCm/) and I did work with json data in your code. The same problem occurs, always subtract 1 day. If you replace your part of html and javascript that designed by me (https://jsfiddle.net/SysProfile/65wx0zqr/) you can check the error.

Please email me if you need any cooperation from me.

[SysProfileParticipant]

This is json result

[{"opr_lst_ftp_id":" ","opr_obs_id":"1","cmn_leg_ref_refclnt_pri_referencia":null,"cmn_leg_ref_refclnt_sec_referencia":"229900","cmn_legajos_id":"428485","cmn_lst_clientes_desc":"Exiros","cmn_lst_clientes_un_desc":"SIDERAR S.A.I. y C.","cmn_lst_clientes_dest_desc":null,"cmn_legajos_creacion":"2016-03-22","cmn_lst_leg_estados_desc":"SIM autorizado","opr_embarque_eta":"2016-04-01","opr_embarque_eta_dias":"-22","sim_lst_embalajes_desc":null,"opr_embarque_bultos":null,"opr_docrec_fac_dn":"82196, 82643, 82645, 82646, 82647, 82648, 82649, 82654, 82662, 82663, 82667, 82668","opr_docrec_fac_monto":"1683.10, 222.25, 888.00, 535.40, 738.00, 287.70, 2523.00, 497.38, 241.54, 402.57, 10350.00, 5132.00","opr_docrec_fac_condventa":"FCA","opr_lst_provcli_desc":"Houston Overseas Trading Co.","sim_lst_viamedio_desc":"A\u00e9reo","opr_docrec_doc_dn":"31102229","sim_caratula_destsimn":"16073SIMI064698K","sim_caratula_oficializacion":"2016-03-30","opr_djai_org_estado_BI15_fd":"2016-03-31","opr_djai_org_estado_BI15_fv":"2016-09-29","sim_caratula_estado":"SALI","opr_djai_org_estado_BI34_fb":"Si","opr_djai_org_estado_BI34_fd":"2016-04-14","opr_djai_org_estado_BI34_fv":"2016-10-11","opr_djai_org_estado_BI34_estado":"AUTO TOTAL","opr_djai_estado_fp":"2016-03-31","opr_djai_estado_fp_comprobante":"489164","opr_clasif_fgl":null,"opr_lst_obs_tipo_desc":"Impo Oper. - Otros \/ Observaciones, Impo Oper. - Intervenciones"},{"opr_lst_ftp_id":"428751","opr_obs_id":"1","cmn_leg_ref_refclnt_pri_referencia":null,"cmn_leg_ref_refclnt_sec_referencia":"181882","cmn_legajos_id":"428751","cmn_lst_clientes_desc":"Exiros","cmn_lst_clientes_un_desc":"Metalmec\u00e1nica S.A.","cmn_lst_clientes_dest_desc":null,"cmn_legajos_creacion":"2016-03-23","cmn_lst_leg_estados_desc":"Intervenida","opr_embarque_eta":"2016-04-01","opr_embarque_eta_dias":"-22","sim_lst_embalajes_desc":null,"opr_embarque_bultos":null,"opr_docrec_fac_dn":"0266129-IN","opr_docrec_fac_monto":"56.00","opr_docrec_fac_condventa":"FCA","opr_lst_provcli_desc":"Hallmark Sales Corporation","sim_lst_viamedio_desc":"A\u00e9reo","opr_docrec_doc_dn":null,"sim_caratula_destsimn":"16092SIMI065011Y","sim_caratula_oficializacion":"2016-04-01","opr_djai_org_estado_BI15_fd":"2016-04-02","opr_djai_org_estado_BI15_fv":"2016-09-28","sim_caratula_estado":"OBSR","opr_djai_org_estado_BI34_fb":"Si","opr_djai_org_estado_BI34_fd":"2016-04-03","opr_djai_org_estado_BI34_fv":"2016-09-30","opr_djai_org_estado_BI34_estado":"OBSERVADO","opr_djai_estado_fp":"2016-04-04","opr_djai_estado_fp_comprobante":"491647","opr_clasif_fgl":null,"opr_lst_obs_tipo_desc":"Impo Oper. - Auto de Impo, Impo Oper. - Intervenciones, Impo Oper. - Otros \/ Observaciones"},{"opr_lst_ftp_id":" ","opr_obs_id":"1","cmn_leg_ref_refclnt_pri_referencia":null,"cmn_leg_ref_refclnt_sec_referencia":"229902","cmn_legajos_id":"428890","cmn_lst_clientes_desc":"Exiros","cmn_lst_clientes_un_desc":"SIDERAR S.A.I. y C.","cmn_lst_clientes_dest_desc":null,"cmn_legajos_creacion":"2016-03-28","cmn_lst_leg_estados_desc":"SIM autorizado","opr_embarque_eta":"2016-04-01","opr_embarque_eta_dias":"-22","sim_lst_embalajes_desc":null,"opr_embarque_bultos":null,"opr_docrec_fac_dn":"MM 458279","opr_docrec_fac_monto":"15537.52","opr_docrec_fac_condventa":"FCA","opr_lst_provcli_desc":"Thermo Fisher Scientific","sim_lst_viamedio_desc":"A\u00e9reo","opr_docrec_doc_dn":"65405045","sim_caratula_destsimn":"16073SIMI071015Y","sim_caratula_oficializacion":"2016-04-07","opr_djai_org_estado_BI15_fd":"2016-04-08","opr_djai_org_estado_BI15_fv":"2016-10-07","sim_caratula_estado":"SALI","opr_djai_org_estado_BI34_fb":"Si","opr_djai_org_estado_BI34_fd":"2016-04-09","opr_djai_org_estado_BI34_fv":"2016-10-06","opr_djai_org_estado_BI34_estado":"OBSERVADO","opr_djai_estado_fp":"2016-04-07","opr_djai_estado_fp_comprobante":"496247","opr_clasif_fgl":null,"opr_lst_obs_tipo_desc":"Impo Oper. - Otros \/ Observaciones"},{"opr_lst_ftp_id":" ","opr_obs_id":"1","cmn_leg_ref_refclnt_pri_referencia":null,"cmn_leg_ref_refclnt_sec_referencia":"229932","cmn_legajos_id":"429224","cmn_lst_clientes_desc":"Exiros","cmn_lst_clientes_un_desc":"SIDERAR S.A.I. y C.","cmn_lst_clientes_dest_desc":null,"cmn_legajos_creacion":"2016-03-31","cmn_lst_leg_estados_desc":"Clasificada","opr_embarque_eta":"2016-04-01","opr_embarque_eta_dias":"-22","sim_lst_embalajes_desc":null,"opr_embarque_bultos":null,"opr_docrec_fac_dn":"140002995","opr_docrec_fac_monto":"4430.23","opr_docrec_fac_condventa":"FCA","opr_lst_provcli_desc":"KTB USA Import-Export LLC","sim_lst_viamedio_desc":"A\u00e9reo","opr_docrec_doc_dn":"39716494","sim_caratula_destsimn":"16073SIMI069713D","sim_caratula_oficializacion":"2016-04-06","opr_djai_org_estado_BI15_fd":"2016-04-09","opr_djai_org_estado_BI15_fv":"2016-10-06","sim_caratula_estado":"SALI","opr_djai_org_estado_BI34_fb":"Si","opr_djai_org_estado_BI34_fd":"2016-04-08","opr_djai_org_estado_BI34_fv":"2016-10-05","opr_djai_org_estado_BI34_estado":"OBSERVADO","opr_djai_estado_fp":"2016-04-06","opr_djai_estado_fp_comprobante":"494440","opr_clasif_fgl":null,"opr_lst_obs_tipo_desc":"Impo Oper. - Otros \/ Observaciones, Impo Oper. - Intervenciones"},{"opr_lst_ftp_id":" ","opr_obs_id":"1","cmn_leg_ref_refclnt_pri_referencia":null,"cmn_leg_ref_refclnt_sec_referencia":"229920","cmn_legajos_id":"429229","cmn_lst_clientes_desc":"Exiros","cmn_lst_clientes_un_desc":"SIDERAR S.A.I. y C.","cmn_lst_clientes_dest_desc":null,"cmn_legajos_creacion":"2016-03-31","cmn_lst_leg_estados_desc":"Clasificada","opr_embarque_eta":"2016-04-01","opr_embarque_eta_dias":"-22","sim_lst_embalajes_desc":null,"opr_embarque_bultos":null,"opr_docrec_fac_dn":"INV-2016.0056","opr_docrec_fac_monto":"536.00","opr_docrec_fac_condventa":"FCA","opr_lst_provcli_desc":"Tec-al Trade Gmbh","sim_lst_viamedio_desc":"A\u00e9reo","opr_docrec_doc_dn":"65106711","sim_caratula_destsimn":"16073SIMI069446G","sim_caratula_oficializacion":"2016-04-06","opr_djai_org_estado_BI15_fd":"2016-04-08","opr_djai_org_estado_BI15_fv":"2016-10-06","sim_caratula_estado":"SALI","opr_djai_org_estado_BI34_fb":"Si","opr_djai_org_estado_BI34_fd":"2016-04-08","opr_djai_org_estado_BI34_fv":"2016-10-05","opr_djai_org_estado_BI34_estado":"OBSERVADO","opr_djai_estado_fp":"2016-04-06","opr_djai_estado_fp_comprobante":"493963","opr_clasif_fgl":null,"opr_lst_obs_tipo_desc":"Impo Oper. - Otros \/ Observaciones"}]

[SysProfileParticipant]

Dear Peter,
           I understand what you say, I bought the source code and see in jqxdate.js 4.1.1, written on line 193:
{ id: 'Argentina Standard Time', offset: -180, offsetHours: -3, displayName: '(UTC-03:00) Buenos Aires', supportsDaylightSavingTime: true },

I figured that the error could be the supportsDaylightSavingTime variable: true, I changed to false and got the same result, always subtract 1 day. To understand the function does, I decided not specify a format in that column. This was the result:

Actual value: 22/03/2016

The return value is: Mon Mar 21 2016 21:00:00 GMT-0300 (Hora estándard de Argentina)

The first question I ask myself is, where it gets the value 21:00:00?

I checked my computer, the Web server (apache + php) and my server MariaDB. All computers are correctly synchronized, all computers GMT-3, same date and time.

I reformatted the query using the date_format function ().

If I use the format ‘% Y-% m-% d’, I get Sun April 3, 2016 21:00:00 GMT-0300
If I use the format ‘% m-% d-% Y’, I get Tue Mar 29 2016 21:00:00 GMT-0300
If I use the format ‘% d-% m-% Y’, I get Tue May 2018 21:00:00 GMT-03 0300

Best Regards,
Sergio Haurat

[SysProfileParticipant]

I can confirm to you: The format and date/time are perfectly synchronized on my servers. Additionally, both are set to GMT-3

Best Regards,
Sergio Haurat

[SysProfileParticipant]

Please could you tell me the string of characters including TZ

Best Regards,
Sergio Haurat

[SysProfileParticipant]

Image from Google Drive

[SysProfileParticipant]

Hi Peter,

My English is the product of using Google Translate, I hope you can understand the following text

Ok, that’s what I’m doing, but if there is an additional function ?, for example valNoMask(). All that developers can avoid the direct use of program functions in javascript, make it more powerful components.

I do not know if it makes any difference, but I bought the product developer license for multiple sites.

[SysProfileParticipant]

The method jqxMaskedInput(“focus”) does not work correctly, I modified my code with the following lines. You can make this change ?, I bought the product (shaurat@sysprofile.com.ar) and would be useful to solve these small details

Original Code
$(“#userID”).jqxMaskedInput(“focus”);

Real solution
$(“#userID :input”).focus();

[SysProfileParticipant]

Dimitar, thanks for your response. My proposal is that the method is integrated into the framework. Not only for this component, also for others such as jqxEditor, jqxInput and all that you can edit

[SysProfileParticipant]

An update with this topic?

[Author]

Posts