Re: Search on Dates

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34836
interpreted = N
texte = 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/ 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)
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/ Anup Setty

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:

Country & Ship-to address & other fields ? (1997) frames & carts (1997) AOL and referrers on target=_blank (2000) Can't find templaes (1997) HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997) NetForms for mail, sorry (1998) Rollovers (1999) Tax Collection for Different Items (2003) Re:Why did PCS send me this? (1999) Date Bug (1998) [WebDNA] linux linux linux (2009) WebCat2 several catalogs? (1997) problems with 2 tags shakur (1997) using webdna to determine pixel parameters (2000) searching within same page (2000) Update quantity (2000) Silly Question (1997) Search in 2 or more catalogs (1997) [WebDNA] Some WebDNA news (2014) WebCat2b13MacPlugIn - More limits on [include] (1997)