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:

    
  1. Re: Date search - yes or no (John Hill 1997)
  2. Re: Date search - yes or no (Kenneth Grome 1997)
  3. Re: Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)
  4. Re: Date search - yes or no (Kenneth Grome 1997)
  5. Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)
>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:

Odd request (2003) $Replace with [founditems] (1997) Calculating Shipping (1997) problems with 2 tags shakur (1997) ShowNext (1997) how to construct a search for not this entire string? (2000) textarea question (1998) attachment (2000) Cart Number sequence (1997) Adding up weights (1998) can WC render sites out? (1997) my price won't move (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) Bug or syntax error on my part? (1997) HTML Editors (1997) ErrorMessages.db (2004) Bug Report, maybe (1997) [ListFiles] context & alias (1997) [TaxableTotal] - not working with AOL and IE (1997) [WriteFile] problems (1997)