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 toremember is that 00 is 2000 not 1900 and all other years have 1900 addedto them. It is also good to know that you can add or subtract days, monthsor years using a modified date format like +00/30/0000 (use 4 zeros forthe year so it doesn't think it's 2000). This will add 30 days. Likewiseyou 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 best11770 Bernardo Plaza Ct. #462 * Catalog and Merchant softwareSan Diego, CA 92128 * http://www.smithmicro.comPhone: 619-675-1106 Fax: 675-0372 ********************************* Associated Messages, from the most recent to the oldest:

Re: Date search - yes or no (John Hill 1997)
Re: Date search - yes or no (Kenneth Grome 1997)
Re: Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)
Re: Date search - yes or no (Kenneth Grome 1997)
Date search - yes or no (grichter@panavise.com (Gary Richter) 1997)

You can do date math with two digit years just fine. The only thing toremember is that 00 is 2000 not 1900 and all other years have 1900 addedto them. It is also good to know that you can add or subtract days, monthsor years using a modified date format like +00/30/0000 (use 4 zeros forthe year so it doesn't think it's 2000). This will add 30 days. Likewiseyou 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 best11770 Bernardo Plaza Ct. #462 * Catalog and Merchant softwareSan Diego, CA 92128 * http://www.smithmicro.comPhone: 619-675-1106 Fax: 675-0372 ********************************* John Hill

DOWNLOAD WEBDNA NOW!

Re: Date search - yes or no

1997

Top Articles:

Related Readings: