Re: Date Range Search not working

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34887
interpreted = N
texte = >The code below doesn't find anything. Do I need brackets around the >[date] and [t_lwdate]? > >[!]Set up variable that is for the date a week ago[/!] >[TEXT]t_lwdate=[Math date]{[date]}-7[/Math][/TEXT] > >[search >db=bulletins.db&eqLISTNAMEdatarq=[blist]&rnCDATEdatarq=[date] >[t_lwdate]&CDATEtype=date&TOPICsort=1&SKUsort=2&TOPICsdir=de] No, you have to put the oldest date first. Searches using rn always fail unless the smallest or earliest or 'first' value actually comes first. ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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: Date Range Search not working (Kenneth Grome 2000)
  2. Date Range Search not working (Larry Orchier 2000)
>The code below doesn't find anything. Do I need brackets around the >[date] and [t_lwdate]? > >[!]Set up variable that is for the date a week ago[/!] >[text]t_lwdate=[Math date]{[date]}-7[/Math][/TEXT] > >[search >db=bulletins.db&eqLISTNAMEdatarq=[blist]&rnCDATEdatarq=[date] >[t_lwdate]&CDATEtype=date&TOPICsort=1&SKUsort=2&TOPICsdir=de] No, you have to put the oldest date first. Searches using rn always fail unless the smallest or earliest or 'first' value actually comes first. ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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/ Kenneth Grome

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:

SSL Certificates (2004) ImageMagick Commands? (2003) OT: Need some feedback, please. (2003) Answer: WebDelivery downloads alias, not original ? (1997) Replace context problem ... and answers (1997) Multiple prices (1997) Show shoppingcart after remove last item (1997) Emailer setup (1997) Thanks... (1999) Setting up shop (1997) Logging purchases (1997) Re1000001: Setting up shop (1997) Single Link browsing (1997) Spellcheck (2003) Unix line endings (2003) [table] question (2007) Nested [SEARCH] and [REPLACE] problem. (1997) Shopping Cart - prices? (1997) Price problem (1997) bug in Webcat OSX (1999)