Re: Date search - yes or no
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11111
interpreted = N
texte = >>>I was going back thru a bunch of old messages and in b15 I know you can do >>>math on dates. Have tested what I want to do [math date] [/math] wise. >>> >>> But I read a message between Grant and Ken that is in my holding area that >>>might be after the release of b15 where I want to search on a field >>>mm/dd/yy and if it is greater than 30 or 60 or 90 days ago then show it and >>>what I read this could not be done yet in b15 >>> >>>Simple yes or no. >>> >>>Don't want to beat my brains out if it is no without me knowing for sure. >>>Only 2 test records sit in the db and the year is yy not yyyy if that makes >>>a differnece if the answer is yes >> >>Hi Gary, >> >>I think it will work, but I haven't tried it. But if possible, you should >>change the date format in your records and in your prefs to mm/dd/yyyy, >>because that's the default for b15. >> >>From what I remember, Grant has more-or-less finalized the date functions >>for this version and I think you're supposed to be able to do almost >>anything you'd want to do with them. My problem has been in getting the >>syntax correct ... and I don't do enough with dates to actually preactice >>with them all that much. >> >>I personally preferred a different date format but I went back to the >>default format so I wouldn't have any problems. >> >> >>Sincerely, Ken Grome ..... ken@iav.com > >Thanks, the dates are going to be sort of manually put in via selecting in >a form. I can change it to 1997 from 97. Want people to search for new >applications release in the last so many days, where I give them a radio >button so they don't mess upGood concept. If people can mess up, they will, that's for sure. Radio buttons are really good (if you don't have too many of them) because the user can see all the choices - all the time - without scrolling or clicking a popup menu. :)Sincerely, Ken Grome ..... ken@iav.com
Associated Messages, from the most recent to the oldest:
>>>I was going back thru a bunch of old messages and in b15 I know you can do >>>math on dates. Have tested what I want to do [math date] [/math] wise. >>> >>> But I read a message between Grant and Ken that is in my holding area that >>>might be after the release of b15 where I want to search on a field >>>mm/dd/yy and if it is greater than 30 or 60 or 90 days ago then show it and >>>what I read this could not be done yet in b15 >>> >>>Simple yes or no. >>> >>>Don't want to beat my brains out if it is no without me knowing for sure. >>>Only 2 test records sit in the db and the year is yy not yyyy if that makes >>>a differnece if the answer is yes >> >>Hi Gary, >> >>I think it will work, but I haven't tried it. But if possible, you should >>change the date format in your records and in your prefs to mm/dd/yyyy, >>because that's the default for b15. >> >>From what I remember, Grant has more-or-less finalized the date functions >>for this version and I think you're supposed to be able to do almost >>anything you'd want to do with them. My problem has been in getting the >>syntax correct ... and I don't do enough with dates to actually preactice >>with them all that much. >> >>I personally preferred a different date format but I went back to the >>default format so I wouldn't have any problems. >> >> >>Sincerely, Ken Grome ..... ken@iav.com > >Thanks, the dates are going to be sort of manually put in via selecting in >a form. I can change it to 1997 from 97. Want people to search for new >applications release in the last so many days, where I give them a radio >button so they don't mess upGood concept. If people can mess up, they will, that's for sure. Radio buttons are really good (if you don't have too many of them) because the user can see all the choices - all the time - without scrolling or clicking a popup menu. :)Sincerely, Ken Grome ..... ken@iav.com
Kenneth Grome
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:
web delivery (1997)
Secure server question (1997)
Emailer setup (1997)
listcookies works only sometimes (1997)
WebCatalog NT beta 18 now available (1997)
Searching multiple records for certain info (2000)
setting username and password using a form. (2000)
Running 2 two WebCatalog.acgi's (1996)
The evolved Server Configuration Queston (2000)
Search Criteria (2000)
Global replace (2000)
Re1000001: Setting up shop (1997)
Dreamweaver noedit ??? (2005)
[sendmail] questions... (1997)
Join us at MacWorld! (1998)
WebCat2 - [format thousands] (1997)
Separate SSL Server (1997)
RE: Tax and ShipCost Problem (1997)
serial number (1998)
Order not created error (1997)