Re: Sorting Dates in a search
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29741
interpreted = N
texte = on 29/03/2000 15:07, Eric Palhof at eric@pcproduction.com wrote:> [search > db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= > 1]This should do it:[searchdb=product.db&rnReceipt_datedatarq=[StartDate]
[EndDate]&asRece ipt_Datesort=1]Just replace the + with a space..Allso, if the date field is in the mm/dd/yy format, you allso need to add 'Receipt_Datetype=date' to the search. I would recommend storing dates as number of days though, like this:[append db=some.db]myDateField=[math]{[date]}[/math][/append]- Nico ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
on 29/03/2000 15:07, Eric Palhof at eric@pcproduction.com wrote:> [search > db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= > 1]This should do it:[searchdb=product.db&rnReceipt_datedatarq=[StartDate][EndDate]&asRece ipt_Datesort=1]Just replace the + with a space..Allso, if the date field is in the mm/dd/yy format, you allso need to add 'Receipt_Datetype=date' to the search. I would recommend storing dates as number of days though, like this:[append db=some.db]myDateField=[math]{[date]}[/math][/append]- Nico ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Nico
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] HTTP Streaming -- impossible? (2010)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
Forms Search Questions (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Reversed words (1997)
Quit revisited (1997)
lookup (1998)
Multiple catalog databases and showcart (1997)
text size limitation (1997)
Webcat 3.0.7 & Webmerchant (2002)
message board (2001)
FileInfo (2004)
[cart] not being interpreted inside [founditems] (1997)
How To question on setting up downloads (1997)
[getchars] questions (1997)
How can I Add several Items into the cart at once? (1997)
wierd crashes for multi-sendmails on NT (1997)
OT: bulletin board spell check (2001)
Frames and WebCat (1997)
Re2: frames & carts (1997)