Sorting Dates in a search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 29738
interpreted = N
texte = Has anyone dealt with a search that must find line data based on a range of dates? I'm able to pass the start and end dates but the search ignores the end date and only works with a start date. The result is a find that list all the dates from the start date which does not sort them. I placed a form variables tags to see if the search criteria was passed to the page so why isn't the date range search in the following code? The sort based on the Receipt date field works only on the Month. I tried placing %m%d%y tags in the string but I need some pointers here.[search db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= 1] ------------------------------------------------------------- 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:

    
  1. Re: Sorting Dates in a search (Nico 2000)
  2. Sorting Dates in a search (Eric Palhof 2000)
Has anyone dealt with a search that must find line data based on a range of dates? I'm able to pass the start and end dates but the search ignores the end date and only works with a start date. The result is a find that list all the dates from the start date which does not sort them. I placed a form variables tags to see if the search criteria was passed to the page so why isn't the date range search in the following code? The sort based on the Receipt date field works only on the Month. I tried placing %m%d%y tags in the string but I need some pointers here.[search db=product.db&rnReceipt_datedatarq=[StartDate]+[EndDate]&asReceipt_Datesort= 1] ------------------------------------------------------------- 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 Eric Palhof

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:

WebCat2final1 crashes (1997) [input] questions (1997) [subtotal] and others (1997) [WebDNA] [createdate] displays today's date on Ubuntu 14.04 / (2014) Dropdown menus (2006) Where is f2? (1997) problems with 2 tags (1997) re: keep W* in front applescript? (try Cron) (1998) creating a 60 fields database (1997) RE: protect tag on NT (1997) WebCat for Unix?? (1997) [WebDNA] "commerce tags" versus "shopping" tags? (specifically what is the Partner Edition?) (2009) Saving Text Areas with Orders (1997) Unexceling (was I need a smart quote...) (1999) PCS Frames (1997) ReadDateFormat (1998) [WebDNA] Need to get off! (2008) Associative lookup style? + bit more (1997) pc (1997) WebCat for Unix (1999)