Re: sorting dates

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 22390
interpreted = N
texte = >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]I tried this and it returns 11/30/0000 no matter what I enter in the 03/00/000 field. asumming that I can get date -3 months, I think this could would work? [search db=customers.db&datetype=date&rndatedata=[math][date][/math] [math date]{[date]}-{00/03/0000}[/math]] [founditems] [date] [name] [ipaddress] [email]
[/founditems]
[/search]--------------------------------------------------------- Get free personalized email at http://geocities.iname.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)
>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]I tried this and it returns 11/30/0000 no matter what I enter in the 03/00/000 field. asumming that I can get date -3 months, I think this could would work? [search db=customers.db&datetype=date&rndatedata=[math][date][/math] [math date]{[date]}-{00/03/0000}[/math]] [founditems] [date] [name] [ipaddress] [email]
[/founditems]
[/search]--------------------------------------------------------- Get free personalized email at http://geocities.iname.com bradeisenberg@iname.com

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:

[Fwd: F3 database munching] (1997) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) help with writefile (1998) Members register & gain access system (1998) banner ad redirection page (1999) More WebMerch<->MacAuthoriz (1997) [WebDNA] [BULK] which of these tags exist in 7.0 (2011) too many nested tags ... (1997) problems with WebCat-Plugin () SHOWIF/HIDEIF empty fields (2005) Practice runs ? (1997) Code to convert relative to absolute URLs in HTML files (2004) Document contains no data 2 (1998) Help with getting rpm file (2002) SKU lookup (1997) What am I doing wrong? (2000) Database Structure? (1998) Re:Emailer and encryption (1997) Showing unopened cart (1997) File dates in WebCatalog .tmpl/.inc (1997)