FiveTech Software tech support forums

Hello Fafi,

have a look at the TRANSFORM - Function.

SET DATE BRITISH
dDate := TRANSFORM( DATE(), @D ) // Shows the Date-Format, defined in SET DATE
Result : 03/05/09

Regards
Uwe

... aGet[1] := SPACE(len(cDBF->cCampo)) aGet[2] := Replicate("9",len(str(cDBF->nCampo))) PICTURE "999,999.99" SET DATE BRITISH SET CENTURY ON aGet[3] := cDBF->dCampo Saludos.

... ( 1st post on Page 2 of this thread) Stefan & Silvio, I was able to reproduce the error which Silvio and Stefan was getting when Set Date British format is specified. Now I am using OpenOffice German version. Now If I don't specify any date format xHarbour fuction Set(_SET_DATEFORMAT) ...

Anser, Did you mean that Date is Displayed as "DD.06.YYYY" instead of "05.06.1991 when Set Date British is ON in your OpenOffice German version? Did Set Date British give you a run time error ?. No, it´s displayed with Set Date German or Set Date Italian in the ...

Dear Mr.Stefan, Really appreciate your effort. Thankyou very much. Can't understand why in OpenOffice German version Set Date British is failing at your end. I tested OpenOffice German version and Set Date British is working fine here. The only problem is the date format in OpenOffice, ...

... german), OpenOffice 3 german It´s always working with Set Date German It´s always working with Set Date Italian It´s not working with Set Date British The only problem is the date format in OpenOffice, the column shows dates like "DD.06.YYYY" instead of "05.06.1991"

Silvio, I ERASE ALSO THIS LINE : Set Date British Please add Set Date Italian , to get the right dateformat I add set date italian but thereis thi s error Application =========== Path and name: C:\work\errori\openoffice\OCalc.Exe ...

Dear Anser, I installed OpenOffice (German Version) and run the test without changing any code ie I did not remove the line Set Date British It worked fine without any errors. May be it is because of the Language and Regional settings on my XP. Anser Yes, maybe it depends on the laguage ...

Dear Stefan and Silvio, I installed OpenOffice (German Version) and run the tested with and without changing the code ie Set Date British It worked fine without any errors. May be it is because of the Language and Regional settings on my XP. I even tried changing the Regional Settings in ...

Silvio,

Silvio wrote:I ERASE ALSO THIS LINE : Set Date British

Please add

Code: Select all  Expand view

Set Date Italian

, to get the right dateformat

I ERASE ALSO THIS LINE : Set Date British IT MAKE ERROR THIS IS MY DIALOG OPTION : http://img292.imageshack.us/img292/1236/errcalc2sn0.jpg THIS IS THE PICTURE OF THE CALC AFTER i RUN THE TEST http://img132.imageshack.us/img132/1462/errcalc3ao8.jpg ...

... I get the date in format "dd/mm/yy" ? fileDate( "C:\apps\myApp.exe" ) ? date() and my configurations is here: SET DATE BRITISH SET CENTURY ON SET( _SET_EPOCH, 1950 ) How I can get the date in this format "dd/mm/yyyy"?? The following sample works perfectly here: ...

... I get the date in format "dd/mm/yy" ? fileDate( "C:\apps\myApp.exe" ) ? date() and my configurations is here: SET DATE BRITISH SET CENTURY ON SET( _SET_EPOCH, 1950 ) How I can get the date in this format "dd/mm/yyyy"??

... Fiz testes neste PRG: #INCLUDE "FIVEWIN.CH" FUNCTION Main() Local cTemp := "MYFILE.DBF", cFileCdx := "MYFILE.CDX" Local nI := 1 SET DATE TO BRITISH SET EPOCH TO 2000 SET CENTURY ON SET DELETED ON REQUEST DBFCDX RDDSETDEFAULT( "DBFCDX" ) IF FILE("MYFILE.CDX") ERASE MYFILE.CDX ENDIF IF FILE("MYFILE.DBF") ...

... #include 'fivewin.ch' #include 'splitter.ch' Static lError Static oWnd Static oLink Static oSay Static cDescripcion Function main() Set Date To British Set Century On Define Window oWnd Mdi oWnd : SetText( "Ayuda nativa MySql" ) oWnd : SetMenu( MainMenu() ) Activate Window oWnd Maximized On ...