Re: [WebDNA] search by range of dates
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103992
interpreted = N
texte =
Yeah a few things. You can't do two fieldnamedata=3Dxx on the same field. Instead, use range. That would be r= nfieldnamedatarq=3Dfirstdate seconddate. Also,=A0TENDAYSAGOtype=3Ddate is not valid; not needed. Use that just for= the fieldname, as you already do in=A0FORMATTED_DATEtype=3Ddate. Please refer to the online docs for guida= nce on searching --=A0http://webdna.us/page.dna?numero=3D69 is a pretty long page, but it has all the info on constructing a search.<= div align=3D"left">
Terry
On Wed, 11 Nov 2009 23:50:15 -0500
sbraun <sbraun1@twcny.rr.com> wrote:
> Thanks Stuart, your help mad= e 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]TENDAYS= AGO=3D[math date]{[date]}-10[/math][/text]
> [search db=3D/
>temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3D= date&TENDAYSAGOtype=3Ddate&leFORMAT
>TED_DATEdatarq=3D[date][!]
> [/!]&geFORMATTED_DATEdata=3D= [TENDAYSAGO]&deFORMATTED_DATEsort=3D1]
>
> Any ideas for me? Thanks,
> sfb
>
>
>= On Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote:
>
>> Add this to your search ...
>>
&g= t;> &FIELDNAMEtype=3Ddate
>>
>> 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
>>>b= efore
>>> today, and 10 days following today.
>>> I can easily set the two before and afte= r variable dates
>>>in xx/xx/
>>> xxxx format, but I can't seem to get the search tag to <= br>>>>return any
>>> results between these two variables.
> ----------------------------= -----------------------------
> This message is sent to you because you are subscribed
>to
> the = mailing list <talk@webdna.us>.
> To unsubscribe, E-mail to: <talk-leave@webdna.us>
> archives: ht= tp://mail.webdna.us/list/talk@webdna.us
> old archives: http://dev.webdna.us/TalkListArchive/
> Bug Reporting= :
>http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D= 288
=A0
Associated Messages, from the most recent to the oldest:Yeah a few things. You can't do two fieldnamedata=3Dxx on the same field. Instead, use range. That would be r= nfieldnamedatarq=3Dfirstdate seconddate. Also,=A0TENDAYSAGOtype=3Ddate is not valid; not needed. Use that just for= the fieldname, as you already do in=A0FORMATTED_DATEtype=3Ddate. Please refer to the online docs for guida= nce on searching --=A0http://webdna.us/page.dna?numero=3D69 is a pretty long page, but it has all the info on constructing a search.<= div align=3D"left">
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...