Difference in dates (SOLVED) tnks Mr. RAO

[Armando]

Mr. Rao And friends:

I have these two codes

First one

Code: Select all  Expand view

            REDEFINE XBROWSE oBrw ID 200 OF oDlg;
                DATASOURCE oRsHdr;
                COLUMNS "HDR_FOL","HDR_FDM","HDR_REF","","","","","","SUC_NOM","HDR_CAN";
                HEADERS "Folio","Fecha","Referencia","Tipo","Unidades","Costos","Unidades","Costos","Sucursal","Can";
                COLSIZES 50,80,80,60,70,75,70,75,110,32;
                PICTURES "@Z 9999999","dd/mmm/yyyy",Nil,Nil,"@Z 9,999,999","@Z 99,999,999.99","@Z 9,999,999","@Z 99,999,999.99",Nil,Nil;
                JUSTIFY {AL_RIGHT,AL_RIGHT,AL_LEFT,AL_LEFT,AL_RIGHT,AL_RIGHT,AL_RIGHT,AL_RIGHT,AL_LEFT,AL_CENTER};
                FOOTERS AUTOSORT

Second one

Code: Select all  Expand view

         REDEFINE XBROWSE oBrw ID 200 OF oDlg;
            DATASOURCE oRsEfe ;
            COLUMNS "EFE_FEC","EFE_VTA","EFE_GAS","EFE_TOT","EFE_EFE","EFE_FAL";
            HEADERS "Fecha","Venta","Gastos","Total","Efectivo","Falta";
            COLSIZES 80,100,100,100,100,100;
            PICTURES "dd/mmm/yyyy","@Z 999,999,999,999.99","@Z 999,999,999,999.99","@Z 999,999,999,999.99","@Z 999,999,999,999.99","@Z 999,999,999,999.99";
            JUSTIFY {AL_RIGHT,AL_RIGHT,AL_RIGHT,AL_RIGHT,AL_RIGHT,AL_RIGHT};
            FOOTERS AUTOSORT
 

In the first example, the name of the month (second column) is displayed in Spanish, example 15/Ene/2023

But in the second code the name of the month (first column) is displayed in English, example 15/Jan/2023

Why?, I couldn't find the solution

Btw, The structure of both columns is defined the same

Code: Select all  Expand view

          "HDR_FDM DATE    NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha del movimiento'," +;
          "EFE_FEC DATE    NOT NULL DEFAULT '0000-00-00' COMMENT 'Fecha de la venta'," +;
 

And the difference is in the same PC

With best regards

[nageswaragunupudi]

1. This has nothing to do with the database. XBrowse displays the date as FW_TRANSFORM( datevalue, "dd/mmm/yyy" ) and it depends on the language setting in the application.

2) Please clarify if you see the difference in the same application or different applications.

3) Please test

Code: Select all  Expand view

? FW_TRANSFORM( Date(), "dd/mmm/yyyy" )
 

and let us know the result.

[Armando]

Mr. Rao:

With your hint I have found the solution, I omitted these two lines of code, sorry, my mistake

Code: Select all  Expand view

   HB_CDPSELECT("ESWIN")
   HB_LangSelect( "ESWIN" )
 

Thank you very much

With best regards