Re: [WebDNA] search by range of dates

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103989
interpreted = N
texte = Add this to your search ... &FIELDNAMEtype=date Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/11/2009, at 1:42 PM, sbraun wrote: > 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 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > 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=topics&category=288 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)
Add this to your search ... &FIELDNAMEtype=date Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 12/11/2009, at 1:42 PM, sbraun wrote: > 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 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > 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=topics&category=288 Stuart Tremain

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:

different show next (1997) Setting up shop (1997) [WebDNA] test (2015) Secure Server basic question... (1997) WebCatalog for guestbook ? (1997) quantity [addlineitem] (2001) Search Engine bots (2002) [isfolder] and [filename] (1997) Empty Shopping Carts (1998) Shopping cart not being assigned (1999) problems with 2 tags (1997) PCS Frames (1997) My slower response (1997) dates and hex formatting (1997) Deleting Orders (1997) Getting total number of items ordered (1997) Redirect (2000) Latin Characters (1998) [WebDNA] Search on a database (2012) Unknown exception in WebDNA 4.5.0 (2003)