Textpipelines and date fields?

rbuser

Hi All,

I'm having a bit of trouble displaying dates within the reports that are
read via TextPipelines.
The field in the pipeline is set to dtDate and the display format has been
set.

When dropping the field onto a format and previewing it the field is blank
regardless of what formatting
settings I use. If I change the field to a dtString the data displays
correctly.

I'm presuming RB is blanking the field as it thinks the data is incorrect??
but I've no idea what to change to get it
to display. I've tried several formats i.e dd/mm/yyyy, yyyy-mm-dd etc but
the field is always blanked out

any ideas as I'm stumped!!

Many thanks

Chris Hedges

nardmoseley

The TextPipeline supports the standard Delphi TDateTime format - which is a
double. From the Delphi help for TDataTime:

type TDateTime = type Double;

The integral part of a Delphi TDateTime value is the number of days that
have passed since 12/30/1899. The fractional part of the TDateTime value is
fraction of a 24 hour day that has elapsed.

The TDate datatype is defined as

TDate = type TDateTime;

TDate represents a special type of TDateTime value that has no decimal part.

Internally the TextPipeline parses and reads the text field values. For a
Date field, it uses Delphi's StrToFloat function to convert the string field
value to a double and then typecasts the double as a TDateTime.




--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Thanks, I was thinking it must be expecting the value to be a double