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 - 3months 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 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 - 3months 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 | Typhoon619/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:
WebCat and Personal Web Server (1998)
Navigator 4.01 (1997)
Banner DNA (1997)
unsubscribe (1997)
SKU lookup (1997)
Here we go again... was: DDEConnect not working (2006)
2.0.1 new commands and contexts (1997)
[CART] (1997)
RE: Going to anchors within a template page (1997)
Finalizing Orders (2000)
Help! WebCat2 bug (1997)
RAM variables (1997)
[OT] Bad Hard Drive? (2003)
ShowNext (1997)
[WebDNA] WebDNA & Facebook (2011)
Re:Dumb Question about Docs (1997)
OT: FTP problems (2003)
Sendmail (1997)
[WebDNA] Manual install on Manjaro and MariaDB (2017)
can WC render sites out? (1997)