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:
Bug Report, maybe (1997)
How to upgrade from 3.04 to 3.08? And Netcraft (2000)
Nested vs conditional (1997)
Announcement-WebCatalog 2.0 Released (1997)
Running _every_ page through WebCat ? (1997)
too many nested [xxx] (1997)
[SHOWIF AND/OR] (1997)
Dealing with da back button (1999)
passing search criteria (1997)
WebCat2b15MacPlugin - [protect] (1997)
[convertchars] problem... (2000)
POP Mail Server Reseting (1998)
Major Security Hole (1998)
Extended [Concvertchars] needed (1997)
Search design (1997)
searchable list archive (1997)
How to Sort Summ data ? (1997)
Pithy questions on webcommerce & siteedit (1997)
WebCatalog for guestbook ? (1997)
Template transformed itself into a database? (1998)