I'm still having difficulty with the date formatting. (I did a
work-around for the previous problem.)
I have a field called Remit.Sent. If I print this field with %s as the
format, I get 08/02/2004. What I want is August 2, 2004, so I tried
using format = "'%B %e, %Y'" but I get nothing printed out. If I use
format = "'!@%B %e, %Y'" I get a 1, which isn't even part of the date.
I could do a work around for this, also, which involves doing a query to
the table, substringing the date parts, and using an array of month
names to construct the date in a variable, which I would then put in the
query that is passed to rlib. But I really think these date formats
should work.
- Carol
Try the date formatting with out the !@
- bob
On Tue, 2004-10-26 at 16:53 -0600, Carol Fouse wrote:
> Here's something that looks weird.
>
> If I have
>
> <field value="date()" format="'!@%d-%b-%y'"/>
>
> I get 26-Oct-04.
>
> But if I have
>
> <field value="Year.FinUpd" format="'!@%d-%b-%y'"/>
>
> where Year.FinUpd is "08/09/2004", I just get 2004.
>
> If I just have
>
> <field value="date()"/>
>
> I get 10/26/2004, so my Year.FinUpd is in the same format as date(),
> so why do I not get the same result (except for the actual data)with
> the format string?
>
|