Re: HELP WITH DATES
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10468
interpreted = N
texte = >No, not that kind of date...>>The [math] context now understands how to work with dates and we're trying>to decide what the standard behavior should be. Please let us know how you>feel on these various options:>>Note: Dates are automatically detected in the math context as long as they>are in the following form
//. This means that>division of that sort (which I don't thing anyone would ever do) is not>permitted.>>1. dates are automatically converted to an integer value (days since 1/1/0)>and then added, subtracted, etc. This means that if you add 0/0/1 to todays>date you will really be adding 365 days which may not give you todays date>a year from now because of leap years. However, it does let you easily>subtract two dates to get the days between them so they can be used for an>input somewhere else. The result of the math will be an integer value that>you can convert back to a date using the [format] context (with a parameter>of days_to_date: [format days_to_date][math]...[/math][/format].>>2. if any date is detected in the math context, then the entire expression>will be evaluated and output as a date. That is, you can add 12/8/65+0/0/31>and you will get 12/8/96 regardless of leap years. And, the result of the>math expression will be 12/8/96 so there is no need to wrap the [format]>context around it. However, if you want to subtract two dates to get the>number of days between them you will need to format the date as days (for>example [format date_to_days][math]...[/math][/format]). Also, any integers>in the expression will be assumed to be days and handled appropriately.I will be doing lots of subtracting, todays date - (option 30, 60, 90) ie:show me new products in the last 30, 60 or 90 days, etc. Figure it out anddo a search on the record via (greater than). So you say in 1 above.>However, it does let you easily subtract two dates.So I guess I would want 1.===============================================Gary Richter, President 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===============================================------------------------------------To leave this talk list send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------
Associated Messages, from the most recent to the oldest:
>No, not that kind of date...>>The [math] context now understands how to work with dates and we're trying>to decide what the standard behavior should be. Please let us know how you>feel on these various options:>>Note: Dates are automatically detected in the math context as long as they>are in the following form //. This means that>division of that sort (which I don't thing anyone would ever do) is not>permitted.>>1. dates are automatically converted to an integer value (days since 1/1/0)>and then added, subtracted, etc. This means that if you add 0/0/1 to todays>date you will really be adding 365 days which may not give you todays date>a year from now because of leap years. However, it does let you easily>subtract two dates to get the days between them so they can be used for an>input somewhere else. The result of the math will be an integer value that>you can convert back to a date using the [format] context (with a parameter>of days_to_date: [format days_to_date][math]...[/math][/format].>>2. if any date is detected in the math context, then the entire expression>will be evaluated and output as a date. That is, you can add 12/8/65+0/0/31>and you will get 12/8/96 regardless of leap years. And, the result of the>math expression will be 12/8/96 so there is no need to wrap the [format]>context around it. However, if you want to subtract two dates to get the>number of days between them you will need to format the date as days (for>example [format date_to_days][math]...[/math][/format]). Also, any integers>in the expression will be assumed to be days and handled appropriately.I will be doing lots of subtracting, todays date - (option 30, 60, 90) ie:show me new products in the last 30, 60 or 90 days, etc. Figure it out anddo a search on the record via (greater than). So you say in 1 above.>However, it does let you easily subtract two dates.So I guess I would want 1.===============================================Gary Richter, President 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===============================================------------------------------------To leave this Talk List send an email to macjordomo@smithmicro.comwith BODYunsubscribe WebDNA-Talk------------------------------------
grichter@panavise.com (Gary Richter)
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:
WebCat 5 Intranet Question (2003)
[WebDNA] WebDNA 7 and Deprecated command (2011)
RE: Help name our technology! (1997)
OFF-TOPIC: WebDNA hosting ... (2003)
[WebDNA] Two different mail servers? (2011)
The last version of webcat (1999)
Date problems-more (1997)
Is Webcatalog 2.1 NT Ready? (1998)
RE: [WebDNA] [WSC] WebDNA Development Summit (2014)
Re:Virtual hosting and webcatNT (1997)
Search in 2 or more catalogs (1997)
Anybody see this before? (2006)
wild question (1998)
Search with Special Chars (1997)
different ship dates and shopping carts -- how to? (1997)
[delete] problem (2002)
Help! WebCat2 bug (1997)
answers - opinions? (1998)
Help formatting search results w/ table (1997)
WebCat2b12 - nesting [tags] (1997)