Search on Dates

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34833
interpreted = N
texte = I give up.Would someone give me an idea how, after I have pulled a date out of a database (i.e.: 05/01/2000), I can then re-format it as a month only (05, or May)?Or maybe how just to pull May's records out of the database. Anything I try with [date %m] etc or [format] gives me today's date, not the database field.I'm trying to do a sales report. I want to do summaries by month, as well as detail reports, etc.Windows. WebCat 3.0I'm sure there is an elegant solutions that I am missing.Many thanks.Frank------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Search on Dates (frank@usinter.net 2000)
  2. Re: Search on Dates (Joseph D'Andrea 2000)
  3. Re: Search on Dates (Anup Setty 2000)
  4. Search on Dates (frank@usinter.net 2000)
I give up.Would someone give me an idea how, after I have pulled a date out of a database (i.e.: 05/01/2000), I can then re-format it as a month only (05, or May)?Or maybe how just to pull May's records out of the database. Anything I try with [date %m] etc or [format] gives me today's date, not the database field.I'm trying to do a sales report. I want to do summaries by month, as well as detail reports, etc.Windows. WebCat 3.0I'm sure there is an elegant solutions that I am missing.Many thanks.Frank------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ frank@usinter.net

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Cookies and webcat (1997) [OT] What log analyzer do you use? (2000) Frames and WebCat (1997) Extra carriage returns (1999) RE: type 2 errors with ssl server (1997) Frames and WebCat (1997) Webcat data and graphing (2000) creating a ShipCosts database (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Determining Method (2000) Location of Webcat site in folder hierarchy (1997) New Image Gallery using WebDNA and ImageMagick (2003) One other big addition... (1997) info (1997) Same DB Same Time (2004) Almost a there but..bye bye NetCloak (1997) PCS Frames (1997) Math (1997) Duplicate Cart Problem in Netscape (2000) [WebDNA] AJAX module (2012)