Re: [WebDNA] search by range of dates
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103990
interpreted = N
texte = Thanks Stuart, your help made sense, so I added it, but it's still not working for me.I'm trying to return only the records within the preceding 10 days.here's my code, the field name is FORMATTED_DATE:[text]TENDAYSAGO=[math date]{[date]}-10[/math][/text][search db=/ temp.db&grSKUdata=0&FORMATTED_DATEtype=date&TENDAYSAGOtype=date&leFORMAT TED_DATEdatarq=[date][!][/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1]Any ideas for me? Thanks,sfbOn Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote:> Add this to your search ...>> &FIELDNAMEtype=date>> Regards> Stuart Tremain> On 12/11/2009, at 1:42 PM, sbraun wrote:>>>> I wish to run a search to find a range of dates 10 days before >> today, and 10 days following today.>> I can easily set the two before and after variable dates in xx/xx/ >> xxxx format, but I can't seem to get the search tag to return any >> results between these two variables.
Associated Messages, from the most recent to the oldest:
Thanks Stuart, your help made sense, so I added it, but it's still not working for me.I'm trying to return only the records within the preceding 10 days.here's my code, the field name is FORMATTED_DATE:
[text]TENDAYSAGO=[math date]{
[date]}-10[/math][/text][search db=/ temp.db&grSKUdata=0&FORMATTED_DATEtype=date&TENDAYSAGOtype=date&leFORMAT TED_DATEdatarq=
[date][!][/!]&geFORMATTED_DATEdata=[TENDAYSAGO]&deFORMATTED_DATEsort=1]Any ideas for me? Thanks,sfbOn Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote:> Add this to your search ...>> &FIELDNAMEtype=date>> Regards> Stuart Tremain> On 12/11/2009, at 1:42 PM, sbraun wrote:>>>> I wish to run a search to find a range of dates 10 days before >> today, and 10 days following today.>> I can easily set the two before and after variable dates in xx/xx/ >> xxxx format, but I can't seem to get the search tag to return any >> results between these two variables.
sbraun
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:
Formating found categories (1997)
multi-paragraph fields (1997)
Sorting problem (2002)
[WebDNA] unique words (2009)
Keep away (1997)
Emailer (1997)
[WebDNA] Conditional search (2009)
writefiles (1999)
WebCatalog on G3 Macs? (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
DON'T UPGRADE, was 4.0.x find (2000)
Email Send Delay (2004)
RE: type 2 errors with ssl server (1997)
WebCat for Unix?? (1997)
EIMS Problems (1997)
Running _every_ page through WebCat ? (1997)
Country & Ship-to address & other fields ? (1997)
[BULK] [WebDNA] port from mime headers? (2017)
Re:Emailer Set Up (1997)
Date search bug (1998)