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, sfb On 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:

    
  1. Re: [WebDNA] search by range of dates (sbraun 2009)
  2. Re: [WebDNA] search by range of dates (Govinda 2009)
  3. Re: [WebDNA] search by range of dates (Donovan Brooke 2009)
  4. Re: [WebDNA] search by range of dates (Govinda 2009)
  5. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  6. Re: [WebDNA] search by range of dates (sbraun 2009)
  7. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  8. Re: [WebDNA] search by range of dates ("Terry Wilson" 2009)
  9. Re: [WebDNA] search by range of dates (Govinda 2009)
  10. Re: [WebDNA] search by range of dates (sbraun 2009)
  11. Re: [WebDNA] search by range of dates (Stuart Tremain 2009)
  12. [WebDNA] search by range of dates (sbraun 2009)
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, sfb On 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)