Re: Date search - yes or no
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11106
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.comThanks, the dates are going to be sort of manually put in via selecting ina form. I can change it to 1997 from 97. Want people to search for newapplications release in the last so many days, where I give them a radiobutton so they don't mess up===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.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.comThanks, the dates are going to be sort of manually put in via selecting ina form. I can change it to 1997 from 97. Want people to search for newapplications release in the last so many days, where I give them a radiobutton so they don't mess up===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
grichter@panavise.com (Gary Richter)
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:
RE: WebCatalog2 for NT Beta Request (1997)
Authenticate (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Euro WebDNA Conference (2004)
Finding max value for a field (1997)
ErrorMessages.db suggestion (1997)
WC2b12: Yes, Formulas.db is for real (1997)
Banners (1997)
[OT] Tiny bit of java help please (2005)
HELP WITH DATES (1997)
Appending Information from one db to another (1998)
Running _every_ page through WebCat ? (1997)
Resume Catalog ? (1997)
Shownext from POST (2000)
Looking up two prices in database? (1997)
unable to launch acgi in WebCat (1997)
Mac v. NT (1998)
X etc.... (1999)
instant cookies? (1999)
Summary layout (1997)