topic-39371

damianodec

Posts: 434

Joined: Wed Jun 06, 2007 02:58 PM

xbrowse to excel field date
Posted: Fri Sep 18, 2020 07:55 AM

hi,
I have a xbrowse with:

code description date

aaa door 11/07/2020
bbb book 31/07/2020
...

date format is dd/mm/yyyy

when I use xbrowse:toexcel function and get my excel file("it" language) field date is in text format and not in date format,

how can I to get date field in date format in excel?

thanks

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse to excel field date
Posted: Fri Sep 18, 2020 01:50 PM

Does xbrowse know that column 3 is a date?
How did you define columns in xbrowse?

Regards

G. N. Rao.

Hyderabad, India

damianodec

Posts: 434

Joined: Wed Jun 06, 2007 02:58 PM

Re: xbrowse to excel field date
Posted: Sat Sep 19, 2020 08:10 AM

hi Mr Rao
column date comes from a ado object.
it read a Db2 table from as400.
in the sql select column date is a date field
SELECT code, description, date...

code and description are varchar and date is date field.

thank you.

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: xbrowse to excel field date
Posted: Sat Sep 19, 2020 08:15 AM

After reading the recordset, can you please do this simple test?

Code (fw): Select all Collapse

? oRs:Fields( "date" ):Type
? ValType( oRs:Fields( "date" ):Value )

Regards

G. N. Rao.

Hyderabad, India

damianodec

Posts: 434

Joined: Wed Jun 06, 2007 02:58 PM

Re: xbrowse to excel field date
Posted: Tue Sep 22, 2020 01:03 PM

thank you mr Rao, field was char from select.

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

FiveTech Support Forums

code description date

Continue the discussion