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:

textarea inputs and returns (1999) Format question WC Mac f3 (1997) WebCat2b12--[searchstring] bug (1997) [WebDNA] OT: just poking (2010) Separate SSL Server (1997) WebDNA for Dummies (2004) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) RAM variables (1997) Sort Issue? (2000) Add (1998) Emailer & IMail List Server (1998) Virtual hosting and webcatNT (1997) WebCat editing, SiteGuard & SiteEdit (1997) previous orders (2002) taxTotal (1997) format problem on NT? (1997) Search/sort in URL Was: GuestBook example (1997) popups, netscape vs explorer (1997) So many lookers, hey smith micro (2003) WebCat2 beta 11 - new prefs ... (1997)