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:

Forms Search Questions (1997) emailer (1997) RE: WebCatalog NT beta 18 now available (1997) WebDNA Commerce Single for MAC 6.0 (2008) re:Clickable maps and WebCatalog? (1996) Searching multiple Databases (1997) RE: Help name our technology! (1997) GrandTotal not right (1997) Getting Total Quantity (1997) unable to launch acgi in WebCat (1997) Webcatalog, Webstar and Crasharama (1999) Re:Emailer (1998) WebCatalog Hosting (1996) WCf2 and nested tags (1997) Big Databases (1997) Can't use old cart file (was One more try) (1997) AAgghh!! Help, please. SSL strikes again. (1997) Here's how to kill a Butler Database. (1997) webdelivery.tmpl???? (1997) NT [delete] (1998)