Reading Excel date-time custom format

Reading Excel date-time custom format

Postby Marc Vanzegbroeck » Mon Feb 05, 2018 6:54 pm

Hi,

I receive an excel-sheet from an Third party program with a cell of custom format
jjjj-mm-dd uu:mm:ss,000 (in English yyyy-mm-dd hh:mm:ss,000)

If I read it with oSheet:Cells( rij, kolom ):Value , I only get the jjjj-mm-dd.
How can I get also the time?

Thanks
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1157
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: Reading Excel date-time custom format

Postby Marc Vanzegbroeck » Mon Feb 05, 2018 7:51 pm

Found it...
TTOS() :D
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1157
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot], richard-service and 10 guests