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:

Mime Headers for Mail (1998) Generating Report Totals (1997) Requiring that certain fields be completed (1997) New commands in Final candidate (1997) math with a [numfound] (2005) How to include weather (2000) [format xs] freeze (1997) WebCat2 - [SendNews] (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) webcat- multiple selection in input field (1997) WebCat2 - [format thousands] (1997) keep W* in front applescript? (1998) Custom WebCat Prefs ... (1997) [WebDNA] General email error -1 (WebDNA 7) (2012) RE: ShowNext Command (1997) Secure server question (1997) Closest non matching search (2004) WebCat2.0 [format thousands .0f] no go (1997) Image editing in browser (2005) FlushDatabase Suggestion (1998)