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:
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)