xbrowse to excel field date

[damianodec]

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

[nageswaragunupudi]

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

[damianodec]

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.

[nageswaragunupudi]

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

Code: Select all

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

[damianodec]

thank you mr Rao, field was char from select.