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=3D[math =date]{[date]}-10[/math][/text]
[search =db=3D/temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3Ddate&TENDAYSA=GOtype=3Ddate&leFORMATTED_DATEdatarq=3D[date][!]
[/!]&geFORMATT=ED_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 ...&FIELDNAMEtype=3DdateRegardsStuart =TremainOn 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.
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>
archi=ves: http://mail.webdna.us/l=ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi=stArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288=
|
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=3D[math =date]{[date]}-10[/math][/text]
[search =db=3D/temp.db&grSKUdata=3D0&FORMATTED_DATEtype=3Ddate&TENDAYSA=GOtype=3Ddate&leFORMATTED_DATEdatarq=3D[date][!]
[/!]&geFORMATT=ED_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 ...&FIELDNAMEtype=3DdateRegardsStuart =TremainOn 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.
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>
archi=ves: http://mail.webdna.us/l=ist/talk@webdna.us
old archives: http://dev.webdna.us/TalkLi=stArchive/
Bug Reporting: http://forum.webdna.us/eucabb.html?page=3Dtopics&category=3D288=
DOWNLOAD WEBDNA NOW!
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...