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=dateRegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 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:
Add this to your search ...&FIELDNAMEtype=dateRegardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 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)