FiveTech Software tech support forums

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

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

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.

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

thank you mr Rao, field was char from select.