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:

[convertchars] problem... (2000) Cart Question: The Epic Saga (1998) [LOOKUP] (1997) Formating found categories (1997) Webcat/Webmerchant part II (1998) PROBLEM (1997) CAPTCHA system in webDNA (2005) Setting up WebCatalog with Retail Pro data (1996) redirect & arguments (2001) The future of WebCatalog is coming with 4.0... (2000) looping through the headers of an orderfile (2000) [WebDNA] Error 500 with SUMM=T (2017) PCS Emailer's role ? (1997) 2.0 Info (1997) Problem with summ=T & [sum fieldname=] (2001) [WebDNA] UTF-8 encoding issues (2010) syntax question, not in online refernce (1997) What am I doing wrong? --GOT IT! (2000) Admin Edit prob. (1997) Calculating a total (2000)