Re: Newbie search question (between two dates)
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 39465
interpreted = N
texte = Your problem is not with your search, which is fine, but rather with your math variable weeks... What you are storing in weeks is the math equivalent of a date, the number of days since 12/31/0000. What you need in your search is the text format of the date. So, try setting a text variable instead, like this:[text]weeks=[math date]{[date]}+14[/math][/text]- Brian At 4:18 PM 10/18/2001, Matthew Bohne wrote: >I have an event date, and corrosponding description information: >eventdate and eventdesc respectively. > >I need to display all events from today until two weeks from today >out of a .db called norcalendar.db > >[math date]weeks={[date]}+14[/math] >[search >db=norcalendar.db&xreventdatedata=[weeks]&mreventdatedata=[date]&eventdatetype=date&eventdatesort=1] >[founditems] >
> | > [eventdate] > | > > [eventdesc] > | >
>[/founditems] >[/search] > >What am I doing wrong? Thanks. > >-- >Matthew C. Bohne -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Your problem is not with your search, which is fine, but rather with your math variable weeks... What you are storing in weeks is the math equivalent of a date, the number of days since 12/31/0000. What you need in your search is the text format of the date. So, try setting a text variable instead, like this:[text]weeks=[math date]{[date]}+14[/math][/text]- Brian At 4:18 PM 10/18/2001, Matthew Bohne wrote: >I have an event date, and corrosponding description information: >eventdate and eventdesc respectively. > >I need to display all events from today until two weeks from today >out of a .db called norcalendar.db > >[math date]weeks={[date]}+14[/math] >[search >db=norcalendar.db&xreventdatedata=[weeks]&mreventdatedata=[date]&eventdatetype=date&eventdatesort=1] >[founditems] > > | > [eventdate] > | > > [eventdesc] > | >
>[/founditems] >[/search] > >What am I doing wrong? Thanks. > >-- >Matthew C. Bohne -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Brian Fries
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:
Random Images (2000)
Secure server question (1997)
Some Questions (1997)
Purchase command error problem (1997)
Navigator 4.0 & tables (1997)
Appending with +1 ... (1997)
Regular expression to match email address (2003)
[WebDNA] [OT] WebDNA Server Beta (2013)
Interpret twice? (1997)
WCS Newbie question (1997)
emailer (1997)
[OT] Kerio Mailserver (2003)
RE: Formulas.db + Users.db (1997)
[showif] results returned... (2003)
WebCatalog can't find database (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
return two fields w/ [lookup] (1998)
Help with UPS Shipping (2006)
database visibility (2000)
[WebDNA] Announcing the new features for the next WebDNA version (2015)