Re: Date search - yes or no
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11103
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 yesHi 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
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 yesHi 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
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:
Who needs Yoda! (2002)
Email Scavengers (2003)
New Site WebCat (1997)
WebMerchant Orders Won't Process (2002)
Emailer Set Up (1997)
[OT] HTML EMAIL program wanted (1999)
emailer (1997)
Nesting [RAW] (1998)
Best way to download a db (2003)
WebCat2: Items xx to xx shown, etc. (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
New Command prefs ... (1997)
More on the email templates (I like it) (1997)
syntax question, not in online refernce (1997)
two of the same named db's open at once (1998)
removing commas from a preformatted number (2000)
Bug Report, maybe (1997)
Moving Files (2000)
can WC render sites out? (1997)