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 and do 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.com with BODY unsubscribe WebDNA-Talk ------------------------------------ Associated Messages, from the most recent to the oldest:

    
  1. Re: Help with dates (John Peacock 2001)
  2. Re: Help with dates (Gorana Leahy 2001)
  3. Re: Help with dates (Gorana Leahy 2001)
  4. Re: Help with dates (John Peacock 2001)
  5. Re: Help with dates (Will Starck 2001)
  6. Re: Help with dates (John Peacock 2001)
  7. Re: Help with dates (Tom Duke 2001)
  8. Re: Help with dates (Tom Duke 2001)
  9. Re: Help with dates (Gorana Leahy 2001)
  10. Re: Help with dates (John Peacock 2001)
  11. Help with dates (Gorana Leahy 2001)
  12. Re: HELP WITH DATES (Kenneth Grome 1997)
  13. Re: HELP WITH DATES (Jim Shaughnessy 1997)
  14. Re: HELP WITH DATES (John Hill 1997)
  15. Re: HELP WITH DATES (grichter@panavise.com (Gary Richter) 1997)
  16. Re: HELP WITH DATES (Jim Shaughnessy 1997)
  17. Re: HELP WITH DATES (Grant Hulbert 1997)
  18. Re: HELP WITH DATES (Kenneth Grome 1997)
  19. HELP WITH DATES (John Hill 1997)
>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 and do 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.com with BODY unsubscribe 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:

emailer settings and control questions (1997) ShowNext (1997) $flushcache causes crash (2000) Why isn't this working (1999) WebCatalog and WebTen (1997) textarea inputs and returns (1999) Configuring E-mail (1997) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Re2: frames & carts (1997) [WebDNA] Credit card processing (2012) WebCat editing, SiteGuard & SiteEdit (1997) Bug or syntax error on my part? (1997) WebCat2: Items xx to xx shown, etc. (1997) How to display images? (2002) Grep Help (2007) [WebDNA] Feature requests - date format (2009) RE: formula.db, adding option prices (1997) Protecting webdelivery (1997) merchant accts. (1997) Error Lob.db records error message not name (1997)