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:

Cumulative Shipping charge calculations - your help please. (1997) Anyone using Verisign's Payflow Link for payment processing? (2000) RE: [WebDNA] Admin Lag (2009) Wanted: Broader string manipulation functions (1997) Sorting Numbers (1997) TCPSend/Replace DB Records (2002) [isfile] ? (1997) math on date? (1997) searching multiple databases in single search (1997) [WebDNA] php -> WebDNA: Can I do this with [tcpconnect]? (2013) [WebDNA] Stores (2013) Best Place for AuthorizeNet Call (2003) WC2b15 File Corruption (1997) block serving .db files (2002) Re:Password Authentication - request example (1998) select multiple (1997) Purchased cart being overwritten - still !?? (1997) format crash! (1997) Signal Raised (1997) docs for WebCatalog2 (1997)