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:

[WebDNA] macOS 10.13.3 and WebDNA Mac Server 8.5.1 - hick-up (2019) Re:Problem displaying search result (1997) [OT] mozilla / Seamonkey (2007) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Help with Repost Data msg from form (1997) Web Developer Product Awards (1997) Re:no [search] with NT (1997) GrandTotal not right (1997) [WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009) WebCatalog can't find database (1997) WebCat2b15MacPlugin - showing [math] (1997) Limiting user access to .tmpl files (1997) two unique banners on one page (1997) Practice runs ? (1997) Need help with search title (1998) passing along TextB (1999) Bug Report, maybe (1997) File Uploads... (1997) Trouble with formula.db (1997) WebCatalog NT beta 18 problem (1997)