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:
Hyperlink in email (2002)
listword db bolding {correction} (2002)
PROBLEM (1997)
re: keep W* in front applescript? (try Cron) (1998)
RE: Promise of future help (1998)
RED QUESTION MARK (1999)
Signal Raised Error (Part II) (1997)
[WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow (2019)
Forbidden CGI Error (1997)
WebCatalog can't find database (1997)
Emailer help....! (1997)
[LOOKUP] (1997)
Plugin or CGI or both (1997)
WebCatalog can't find database (1997)
New NT betas available (1997)
Re:Item options w/ price adjustment (1997)
Duplicate order authorization attempts (2001)
Frames and WebCat (1997)
Sitebuilder (2004)
Multiple ShipTo Addresses (2003)