Search found 187 matches: yyyy

Return to advanced search

Search by format

Hi,

Is it possible to search in the text by format ?
For example, there is a date in the text in the form of dd/mm/yyyy.
I need to find this fragment and determine that it is exactly the date (a la Excel - mask search "??/??/????")
by Natter
Wed Aug 02, 2023 6:41 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Search by format
Replies: 7
Views: 435

ODBC Date Format

hi,

i notice that Sample c:\fwh\samples\testodbc.prg show DATE as YYYY-DD-MM
i have SET DATE GERMAN but it does not help

how to use ODBC and GERMAN Date Format :?:
by Jimmy
Mon Jul 17, 2023 11:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ODBC Date Format
Replies: 3
Views: 201

Re: PICTURE for DATE() ?

... DATEFORMAT set for the application. At the beginning of the application SET DATE GERMANSET CENTURY ON Then all your dates will appear as dd.mm.yyyy in the entire application. Setting picture everytime we edit a date is waste of time and code space.\ Next, used in the right way, TDataRow and ...
by nageswaragunupudi
Mon Jul 17, 2023 9:06 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: PICTURE for DATE() ?
Replies: 10
Views: 396

Re: Imprimir fechaq

Hola
.......
SET DATE FORMAT "DD/MM/YYYY"
dFecha := DATE()
......
......
oPrn:CmSay(nRow, 1, DTOC(dFecha), oFontE)

......
by Willi Quintana
Tue Jul 11, 2023 1:06 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Imprimir fechaq
Replies: 3
Views: 162

Re: Imprimir fechaq

SET DATE FORMAT "DD/MM/YYYY"
? date()
by cmsoft
Tue Jul 11, 2023 12:51 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Imprimir fechaq
Replies: 3
Views: 162

Re: CLASS modification

... => _FWH( 3560 ) @ nRow, 70 DTPICKER aGet[1] VAR ddatacambio OF oDlgSub SIZE 198, 25 PIXEL ; FONT oFont UPDATE PICTURE "ddd dd mmm yyyy" ; VALID oBtnGetExchange:refresh() STYLE DTS_SHOWNONE
by Silvio.Falconi
Sun May 28, 2023 1:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: CLASS modification
Replies: 33
Views: 1704

Re: calendar not run ( DBLCLICK)

ddatacambio:=CTOD(' ')

@ nRow, 70 DTPICKER aGet[1] VAR ddatacambio OF oDlgSub SIZE 198, 25 PIXEL ;
FONT oFont UPDATE PICTURE "ddd dd mmm yyyy" ;
ON CHANGE oBtnGetExchange:refresh() STYLE DTS_SHOWNONE
by Silvio.Falconi
Sat May 27, 2023 3:57 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: calendar not run ( DBLCLICK)
Replies: 20
Views: 1917

Re: ChatGPT

... Otto https://mybergland.com/fwforum/fragen.jpg Can you please provide me a list of public holidays for 2024 in the format 'DD.MM.YYYY holiday name'? Also, please calculate the tokens for this request and determine the cost for the inquiry. The fee is $0.06/1K tokens. How many ...
by Otto
Tue May 09, 2023 6:58 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ChatGPT
Replies: 19
Views: 1227

Re: Conversión varchar en datetime produjo valor fuera intervalo

... en un formato reconocido por SQL Server. Por ejemplo, si la cadena de caracteres es '2022-12-13', debe asegurarse de que está en el formato 'yyyy-mm-dd', donde yyyy es el año con cuatro dígitos, mm es el mes con dos dígitos y dd es el día con dos dígitos. Una vez que haya asegurado que la ...
by Antonio Linares
Tue Dec 13, 2022 9:11 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Conversión varchar en datetime produjo valor fuera intervalo
Replies: 2
Views: 315

Re: ¿Qué tan seguro es un .EXE Harbour?

... del codigo fuente algun dato sensible, como variable char, por ejemplo el usuario y clave de conexion a mysql. cUser:="xxx" Passw:="yyyy" ¿Hay posibilidad que de alguna manera alguien pueda verlo? Con un editor de ejecutables, por ejemplo, o de otra manera. Gracias. Prueba lo ...
by cnavarro
Mon Nov 21, 2022 7:01 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ¿Qué tan seguro es un .EXE Harbour?
Replies: 14
Views: 1222

¿Qué tan seguro es un .EXE Harbour?

... del codigo fuente algun dato sensible, como variable char, por ejemplo el usuario y clave de conexion a mysql. cUser:="xxx" Passw:="yyyy" ¿Hay posibilidad que de alguna manera alguien pueda verlo? Con un editor de ejecutables, por ejemplo, o de otra manera. Gracias.
by JoseAlvarez
Mon Nov 21, 2022 4:18 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ¿Qué tan seguro es un .EXE Harbour?
Replies: 14
Views: 1222

Re: convert from a txt text file to a dbf with errors - RESOLVED

Actually he converted the date string from the format YYYY/MM/DD to DD/MM/YYYY with this code        AEVAL( aData, { | arr, nIndex | aData[nIndex][1] := SUBSTR( arr[1], 9, 2 ) + "/" ...
by nageswaragunupudi
Sat Sep 17, 2022 4:08 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: convert from a txt text file to a dbf with errors - RESOLVED
Replies: 10
Views: 600

Re: convert from a txt text file to a dbf with errors - RESOLVED

hi Silvio, what DATE Format do you use :?: you got YYYY/MM/DD but there is no DATEFORMAT like that Syntax Date Format ANSI yy.mm.dd BRITISH dd/mm/yy FRENCH dd/mm/yy GERMAN dd.mm.yy ITALIAN dd-mm-yy JAPAN yy.mm.dd USA mm-dd-yy AMERICAN mm/dd/yy so ...
by Jimmy
Sat Sep 17, 2022 10:54 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: convert from a txt text file to a dbf with errors - RESOLVED
Replies: 10
Views: 600

Re: convert from a txt text file to a dbf with errors

It seems that SET DATE to the right format is not set in prg DD.MM.YYYY ?
by alerchster
Sat Sep 17, 2022 7:45 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: convert from a txt text file to a dbf with errors - RESOLVED
Replies: 10
Views: 600

Harbour y MySQL - tildes y eñes

... PROCEDURE Set Exact on request hb_gt_win set talk off set echo off set bell off set confirm off set wrap on set date french set date format 'dd/mm/yyyy' set century on Request DBFCDX, DBFFPT, OrdCreate, OrdKeyCount, OrdKeyNo, OrdKeyGoto RddSetDefault( 'DBFCDX') set deleted on set autopen off set ...
by José
Tue Nov 23, 2021 4:27 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Harbour y MySQL - tildes y eñes
Replies: 14
Views: 1645
Next

Return to advanced search