[Rlib-users] Date formatting

[Carol F. <cf...@eh...>]

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?
>