Re: sorting dates

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22386
interpreted = N
texte = >I want to sort dates by showing ones in the database that were entered the >past month. 2months, 3months etc. > >What would be the simple code for this? I have tried to subtract from the >month number, but what if the present month is 1?The secret is to use [math] with dates. For instance, to get today - 3 months you would use:[math date]{[date]}-{03/00/0000}[/math]Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting Dates in a search (Nico 2000)
  2. Sorting Dates in a search (Eric Palhof 2000)
  3. Sorting Dates (Eric palhof 2000)
  4. Re: Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  5. Re: Crazy dates (was: Re: sorting dates) (Martin Bech 1999)
  6. Re: Crazy dates (was: Re: sorting dates) (John Hill 1999)
  7. Crazy dates (was: Re: sorting dates) (Christer Olsson 1999)
  8. Re: sorting dates (Kenneth Grome 1999)
  9. Re: sorting dates (bradeisenberg@iname.com 1999)
  10. Re: sorting dates (Bill Heissenbuttel 1999)
  11. Re: sorting dates (Bill Heissenbuttel 1999)
  12. Re: sorting dates (PCS Technical Support 1999)
  13. Re: sorting dates (bradeisenberg@iname.com 1999)
  14. Re: sorting dates (PCS Technical Support 1999)
  15. sorting dates (bradeisenberg@iname.com 1999)
  16. sorting dates (bradeisenberg@iname.com 1999)
  17. sorting dates (bradeisenberg@iname.com 1999)
  18. Re: Searching/sorting dates (Grant Hulbert 1997)
  19. Searching/sorting dates (Christer Olsson 1997)
>I want to sort dates by showing ones in the database that were entered the >past month. 2months, 3months etc. > >What would be the simple code for this? I have tried to subtract from the >month number, but what if the present month is 1?The secret is to use [math] with dates. For instance, to get today - 3 months you would use:[math date]{[date]}-{03/00/0000}[/math]Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

[WebDNA] PayPal IPN (was: paypal FINALLY!!!!) (2009) setting cookies for another domain? (2002) Thanks Grant (1997) New Image Gallery using WebDNA and ImageMagick (2003) WebDNA to PHP (2008) Working Days (2004) Requiring that certain fields be completed (1997) WebDNA Intranet Edition release (2002) 100% cpu load (2006) locking variables? (2000) Off Topic - OS X web server, FTP accounts (2003) Making a page expire with web catalog? (1999) [WebDNA] plupload ? (2012) [WebDNA] Captcha question (and free code) (2009) all records returned. (1997) Search multiple fields (1997) Email and name capture (1999) multiple product databases (1997) What about this gremlin issue? (2000) Bug alert! (1997)