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:
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)