Re: Search on Dates

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34850
interpreted = N
texte = Thank you, thank you, thank you. FrankAnup Setty wrote:> You need to do this to get just the month, > [listwords words=[datefield]&delimiters=/] > [showif [index]=1][text]month=[word][/text][/showif] > [/listwords] > > hope this gives you a good start... > > ========================================================== > _O_/\NUP Setty > / | \/ERTical Net > / \ http://www.vertical.net > _\ \_ 336-218-8562 Ext. 218 > o o o o > ========================================================== > ----- Original Message ----- > From: > To: WebCatalog Talk > Sent: Tuesday, July 18, 2000 9:58 PM > Subject: Search on Dates > > > 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.0 > > > > I'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/ > > ------------------------------------------------------------- > 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 Wolfe frank@usinter.net US Internet 2800 28th Street, Suite #215 Santa Monica, CA (310) 581-2811 Voice (310) 581-2831 Fax -------------------------------- Check out US Internet's hot directory of On-line Casinos. http://www.casinolocator.com------------------------------------------------------------- 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)
Thank you, thank you, thank you. FrankAnup Setty wrote:> You need to do this to get just the month, > [listwords words=[datefield]&delimiters=/] > [showif [index]=1][text]month=[word][/text][/showif] > [/listwords] > > hope this gives you a good start... > > ========================================================== > _O_/\NUP Setty > / | \/ERTical Net > / \ http://www.vertical.net > _\ \_ 336-218-8562 Ext. 218 > o o o o > ========================================================== > ----- Original Message ----- > From: > To: WebCatalog Talk > Sent: Tuesday, July 18, 2000 9:58 PM > Subject: Search on Dates > > > 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.0 > > > > I'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/ > > ------------------------------------------------------------- > 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 Wolfe frank@usinter.net US Internet 2800 28th Street, Suite #215 Santa Monica, CA (310) 581-2811 Voice (310) 581-2831 Fax -------------------------------- Check out US Internet's hot directory of On-line Casinos. http://www.casinolocator.com------------------------------------------------------------- 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:

shell problems again... (2003) Shop from PDF (2004) Re(4): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Caching pages...again (2001) Layers,Dreamweaver and WebCat Code (2000) [ShowNext] feature in 2.0 (1997) Problem with version 4 browsers (1998) 2.0 Info (1997) DB permission issues (2004) Post arguments problem mac? (1997) .. more on sliding discounts... (1997) Multiple fields on 1 input (1997) Reloading Shopping Carts (1998) Online reference (1997) [WebDNA] PayPal IPN (was: paypal FINALLY!!!!) (2009) Updating Integer value in DB (2007) RAM variables (1997) NewCart+Search with one click ? (1997) [WebDNA] mod_deflate and webdna (2017) [math] show=F exists? (1997)