It looks good, and you are proving to yourself that the variable is set properly; that's =A0alwa= ys a good idea when problems crop up. Make sure your database actually has some records for the past ten days? And that t= he format in the db is mm/dd/yyyy, not mm/dd/yy, because this won't sort right. (I ran into this recently where = some dates were YY and some were YYYY. They didn't sort right until I made them consistent.)
Also, in your code below,=A0grSKUPdata=3D0 --> where di= d that P come from? maybe this is a typo that's breaking it.=A0
On= Thu, 12 Nov 2009 00:47:57 -0500
sbraun <sbraun1@twcny.rr.com> wrote:
> Hi Terry, I've read the = docs you've mentioned.
> Thank you.
> I've tried your suggestions, along with a dozen other
&g= t;variations, and I either get all the records returned,
>or no records returned.
> This is the current cod= e which returns no records. Am I
>setting the TENDAYSAGO variable wrong? It looks correct
>= ;on my screen.
>
>
[text]TENDAYSAGO=3D[math date]{
[date]}-10[/math][/text]
> TENDA= YSAGO=3D [TENDAYSAGO] <br>
> [search db=3Dassign_events/
>temp.db&grSKUPdata=3D0&FORMATTED_DATE= type=3Ddate&rnFORMATTED_DATEdatarq=3D
>[TENDAYSAGO]
[date]]
>
> I get every past record ret= urned if I use
>{[TENDAYSAGO]}.
> At least it not giving me future dated records anymore.
>
> = Thanks again,
> sfb
>
>
>
> On Nov 12, 2009, at 12:00 AM, Terry Wilson wrote:
&g= t;
>> Yeah a few things. You can't do two fieldnamedata=3Dxx on
>>the same
>> field. Inste= ad, use range. That would be
>> rnfieldnamedatarq=3Dfirstdate seconddate. Also,
>>TENDAYSAGOtyp= e=3Ddate
>> is not valid; not needed. Use that just for the
>>fieldname, as you
>> already= do in FORMATTED_DATEtype=3Ddate. Please refer to
>>the online
>> docs for guidance on searching --
>>http://webdna.us/page.dna?
>> numero=3D69 is a pretty long page, but it has all the info <= br>>>on
>> constructing a search.
>>
>> Terry
>>
>>
>>= On Wed, 11 Nov 2009 23:50:15 -0500
>> sbraun <sbraun1@twcny.rr.com> wrote:
>> > 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, t= he field name is FORMATTED_DATE:
>> >
>> > [text]TENDAYSAGO=3D[math date]{[date]}-10[/math][/t= ext]
>> > [search db=3D/
>> >temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3Ddate&TENDAYSAG= Otype=3Ddate&leFOR
>> MAT
>> >TED_DATEdatarq=3D[date][!]
>> >
>>[/!]&geFO= RMATTED_DATEdata=3D[TENDAYSAGO]&deFORMATTED_DATEsort=3D1]
>> >
>> > Any ideas for me? Thanks,
>> > sfb
&= gt;> >
>> >
>> > On Nov 11, 2009, at 10:01 PM, Stuart Tremain wrote:
>> >
&= gt;> >> Add this to your search ...
>> >>
>> >> &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
>> >>>before
>> >>> = today, and 10 days following today.
>> >>> I can easily set the two before and after variable
>&= gt;dates
>> >>>in xx/xx/
>> >>> xxxx format, but I can't seem to get the = search tag
>>to
>> >>>return any
>> >>> results between these two= variables.
>> >
>>---------------------------------------------------------
= >> > This message is sent to you because you are subscribed
>> >to
>> > the mailin= g list <talk@webdna.us>.
>> > To unsubscribe, E-mail to: <talk-leave@webdna.us>
>> > = archives: http://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=3D288>>
>>
>
> ---------------------------------------------------------
> This me= ssage is sent to you because you are subscribed
>to
> the mailing list <talk@webdna.us>.
> To un= subscribe, E-mail to: <talk-leave@webdna.us>
> archives: http://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=3D288
=A0=