[WebDNA] search by range of dates

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103988
interpreted = N
texte = Hi everyone, I have a .db with a field called formatted_date which contains date data in the format xx/xx/xxxx This .db only as a few hundred records. 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. Do I need to convert everything to an integer to be able to use dates in a search tag? Thanks for any insight, sfb 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)
Hi everyone, I have a .db with a field called formatted_date which contains date data in the format xx/xx/xxxx This .db only as a few hundred records. 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. Do I need to convert everything to an integer to be able to use dates in a search tag? Thanks for any insight, sfb 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:

SiteEdit NewFile.html ? (1997) On a related topic (2006) World Address Info (2003) Hiding HTML and page breaks (1997) Multiple Newcarts (1996) 2nd WebCatalog2 Feature Request (1996) blank page from template (1997) Nested tags count question (1997) Emailer on NT! (1998) how to do multiple prices/item? (1998) international time (1997) GREP Help (2001) many-to-one problem (1998) security problem (1997) WebCat2 Append problem (B14Macacgi) (1997) Apache2 connector (2003) Webcatalog on MacOs (2000) Bad URL reference? (1997) Problems problems problems (1997) PSC recommends what date format yr 2000??? (1997)