WebDB2.2 Dates become strings in Excel
Date: Thu, 10 Feb 2000 11:33:08 +0100
Message-ID: <38A293E4.A0F6113E_at_cern.ch>
Hello,
[Quoted] I am creating a Report with some DATE fields in it. I want to import the result into Excel and work with the dates afterwards. My problem is that Excel does NOT recognize the DATE fields as such, it takes them as 'strings'.
[Quoted] I've seen that the formats of the fields, when WebDB creates the report to pass it to Excel, are 'strings'.
[Quoted] Ex. Report Select with output format = Excel : select name, date_of_birth, to_char(date_of_birth, 'DD/MM/YYYY') from employer
In Excel, both date_of_birth and to_char(date_of_birth...) will have the same format; even if one should be DATE and the other STRING.
Is there a way to keep the DATE format?
[Quoted] Thanks in advance,
Montse Collados Polidura
CERN - Switzerland.
Received on Thu Feb 10 2000 - 11:33:08 CET