Re: Date search - yes or no
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11121
interpreted = N
texte = You can do date math with two digit years just fine. The only thing to remember is that 00 is 2000 not 1900 and all other years have 1900 added to them. It is also good to know that you can add or subtract days, months or years using a modified date format like +00/30/0000 (use 4 zeros for the year so it doesn't think it's 2000). This will add 30 days. Likewise you could add two months with +02/00/0000.John >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 > >=============================================== >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 >=============================================== John A. Hill, V.P. Marketing ********************************* Pacific Coast Software * Home of the Web's best 11770 Bernardo Plaza Ct. #462 * Catalog and Merchant software San Diego, CA 92128 * http://www.smithmicro.com Phone: 619-675-1106 Fax: 675-0372 *********************************
Associated Messages, from the most recent to the oldest:
You can do date math with two digit years just fine. The only thing to remember is that 00 is 2000 not 1900 and all other years have 1900 added to them. It is also good to know that you can add or subtract days, months or years using a modified date format like +00/30/0000 (use 4 zeros for the year so it doesn't think it's 2000). This will add 30 days. Likewise you could add two months with +02/00/0000.John >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 > >=============================================== >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 >=============================================== John A. Hill, V.P. Marketing ********************************* Pacific Coast Software * Home of the Web's best 11770 Bernardo Plaza Ct. #462 * Catalog and Merchant software San Diego, CA 92128 * http://www.smithmicro.com Phone: 619-675-1106 Fax: 675-0372 *********************************
John Hill
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:
Multiple Carts with Mac IE (2002)
WebTen and WebCat (1997)
WC2.0 Memory Requirements (1997)
[encrypt] entire site? (2003)
Field name-subcategory (1997)
How can I Add several Items into the cart at once? (1997)
Grep question [parsing variables] problem (2003)
OT-Load balance (2004)
limiting found items (2001)
Date or time comparisons have bugs ... (1998)
authenticating a second user, the sequel (1997)
Emailer (1997)
PCS Customer submissions ? (1997)
Buying sans cart (1997)
[purchase] (1999)
Adding Shipping Costs based on percent of subtotal (1997)
Ghostly cached webpage (2000)
BBEdit/HTMLcomments/WebCat/[/FONT] (1999)
command line in webDNA 5?! (2003)
sharing cookie recepies (1998)