WebDB2.2 Dates become strings in Excel

From: Montse COLLADOS POLIDURA <Montse.Collados_at_cern.ch>
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

Original text of this message