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 shouldchange 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 functionsfor this version and I think you're supposed to be able to do almostanything you'd want to do with them. My problem has been in getting thesyntax correct ... and I don't do enough with dates to actually preacticewith them all that much.I personally preferred a different date format but I went back to thedefault 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 shouldchange 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 functionsfor this version and I think you're supposed to be able to do almostanything you'd want to do with them. My problem has been in getting thesyntax correct ... and I don't do enough with dates to actually preacticewith them all that much.I personally preferred a different date format but I went back to thedefault 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:
RE: creating writefile data from a nested search (1997)
HTML authentication HTML page (1999)
More on the email templates (1997)
Help! WebCat2 bug (1997)
Banners (1997)
WebCat & cookies (1998)
system crashes, event log (1997)
Form Validation (2000)
WebCatalog vs. Cold Fusion (1998)
2.0 Info (1997)
Webcatalog Future?!? (2000)
Max Include levels (2000)
Sorting by date (1997)
[taxrate] question (1997)
[WebDNA] Nginx (2010)
Emailer (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
RE: Languages (1997)
Shopping Cart ID (1998)
Uploading very large image files (2003)