Home Datapipelines

Textpipelines and date fields?

edited September 2004 in Datapipelines
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

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

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


  • edited September 2004

    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

    Best regards,

    Nard Moseley
    Digital Metaphors
  • edited September 2004
    Thanks, I was thinking it must be expecting the value to be a double

This discussion has been closed.