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:
Mondo amounts of Mail [long] (1999)
[WebDNA] Adding Graphics to Directory (2009)
re:check boxes (1997)
math a various prices (1997)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
WebCat2b15MacPlugin - showing [math] (1997)
Signal Raised Error (1997)
Can WebDNA do this? (2000)
Poll Please (2002)
WebCat2b12 forgets serial # (1997)
PCS Frames (1997)
Help!!!! Purchases not going through! (1997)
Announcing general availabilty of WebDNA 4.5 release (2002)
Multiple download orders of the same product? (1997)
multiple search commands (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
WebCat2b12 CGI Mac -- Problems propagating the cart through (1997)
WebCat & Liststar (1997)
WebCat b13 CGI -shownext- (1997)
[OT] Puget Sound Meteorites? (2004)