Re: [Rlib-users] Date formatting

[Bob D. <bd...@si...>]

You need to tell RLIB that it's a date before you do that

use stod(Remit.Sent)

stod = string to date

- bob

On Fri, 2004-11-12 at 14:35 -0700, Carol Fouse wrote:
> 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?
> > 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by:
> Sybase ASE Linux Express Edition - download now for FREE
> LinuxWorld Reader's Choice Award Winner for best database on Linux.
> http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
> _______________________________________________
> Rlib-users mailing list
> Rli...@li...
> https://lists.sourceforge.net/lists/listinfo/rlib-users