FiveTech Software tech support forums

... ) )  There is one problem with HASH --> JSON --> HASH. Any date values in the original hash are converted to character stings "yyyymmdd". Unless we scan the hash and convert all such values back to date type, the hash can not be used in date calculations. Please try this ...

... "@ZE 99,999,999.999" ; in this XBROWSE there is dAAAAMMGGadata FUNCTION whit single quotes that convert field DATA from YYYYMMDD to DD/MM/YYYY and it works for each row in oRsMovimenti thank you

Numerics and dates are sorted in the order of the values, not as character values.
So the seeks can not be on the initial characters as they appear in the browse.

Numerics: Seek to the value next higher than the value entered.
Dates: Seeks to the value next higher than the value in YYYYMMDD format

... the text file, with this you will always have the information that you need in the local log or online. You can split in little files too: Folder YYYYMMDD Files HHMM - file with info about this Hour/Minute if each 5sec, 12 records/lines

... " / / "  esto es correcto, ambas cadenas de fechas construidas estan fallando, la idea es que hb_DtoS(dFecha) retorna una cadena "YYYYMMDD", hb_StoD(cFecha) transforma una cadena "YYYYMMDD" a formato fecha, de ello se desprende que: "2013" + "1" ...

Silvio APPEND FROM .... converts dates ONLY of the source data is in YYYYMMDD format. In your case you have to create the field as character field with length 10. After importing you have to copy to other file converting date with CTOD() Or you can adopt my ...

... 2 clientes y les instale la misma aplicacion y en uno corria bien y en otro no, daba errores por las fechas, y comence a usarlas en formato ANSI YYYYMMDD talcual como las devuelve DTOS y ya no estoy pendiente de las fechas. este codigo lo acabo de probar en mysql y corre perfecto select * from ...

... AND VENCTO <= '"+DtoS( dFinal ) + "'"  uso dtos en vez de dtoc para convertirlo a string y usar la fecha como ansi "yyyymmdd", asi no tienes problemas con el codigo sql, corre en sql server y mysql.

Dear Marc Vanzegbroeck,

Try use numeric for date with format YYYYMMDD ,

like :

11795129,20120731,42,9,"","Laadbrug",8,1,0,0.00


Thank

kok

... int iParam, ... ) after const char * hb_parc( int iParam, ... ) line 629 before char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */ after const char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */ line 1518 before ULONG hb_snprintf( char * buffer, ...

... * hb_parc( int iParam, ... ) to const char * hb_parc( int iParam, ... ) 627: char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */ to const char * hb_pards( int iParam, ... ) /* retrieve a date as a string yyyymmdd */ 1518: ULONG hb_snprintf( char * buffer, ULONG nSize, ...

... TDicomVRDA - DICOM Value Representation Date        **                                                              **  A date in the format YYYYMMDD                               **                                                              *\**************************************************************/CLASS ...

... If they are not, a runtime error occurs when the APPEND FROM command is invoked. Any date information in <xcFile> must be in the format yyyymmdd to be properly APPENDed. In a network environment, APPEND FROM does not require that the current database file be USEed EXCLUSIVEly or locked ...

... the same principle as one would need for XML. You would need to add definitions for Data, Export Translations (i.e. would date be exported as YYYYMMDD or MM/DD/YYYY, logicals as -1=True, 0=False) I am hoping that perhaps a group of us could come up with a DTD format, then a generic 'class' ...

Two suggestions.

Date may be formatted as yyyy-mm-dd but not as yyyymmdd. This can be done by SET DATE ANSI and use DTOC( dvar ).

For empty dates use null string.

Logicals may be converted as TRUE or FALSE. Excel understands True / False but not YES / NO.