"When you're talking to yourself, and nobody's home..."

Turns out its an RBuilder problem. If I replace the TppVariables in
the report template, then add the RAP code, everything is fine, DATE
and TIMESTAMP both work.

--- In IBObjects@y..., "bztrw" <Byrne.Zumwalt@t...> wrote:
> OK, now I'm learning...This problem only occurs when selecting from
a
> stored proceudre that returns DATE fields; changing the return type
> to TIMESTAMP and modifying the code below to DateTimeToStr solves
the
> problem. So, where does this leave me?
>
> --- In IBObjects@y..., "bztrw" <Byrne.Zumwalt@t...> wrote:
> > D6, RB 6.03
> >
> > Has anyone else encountered/solved the problem with RAP and Date
> > Fields? I cannot get Date values to work with TppVariables and
RAP;
> > they work fine as TppDBText, but when I try to concatenate values
> in
> > RAP I get an On Calc error.
> >
> > For Example: Value := DateToStr(rptPipe['DATE_FIELD']) + ' thru '
+
> > DateToStr(rptPipe['ANOTHER_DATE_FIELD']);
> >
> > The example above works fine if I switch back to a DBPipeline and
> > TIBODataset decendant. In the Data explorer in RAP, the fields
are
> > showing as Date. Unfortunately, I have idea where to even begin
> > looking: IBO, RAP, or IBOPipeline.
> >
> > Thanks in advance.
> >
> > Byrne Zumwalt
> >
> > Byrne.Zumwalt@t...