Re: Another date range search Q

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43293
interpreted = N
texte = Ok then, why does this (from the online docs): [Format Days_To_Date %m/%d/%y]195462[/Format]Return this?: 02/27/*+Latest WebDNA, Win2kadvserv.Why don't I just go home for the day? GK | Why does this search: | [Search db=report.db&eqacctdatarq=[acct]&rnddatedatarq=[startdate] | [enddate]&startdatetype=date&enddatetype=date&ddatetype=date&ddatesort=1&dda | tesdir=de] | | startdate: 7/23/2002 | enddate: 7/30/2002 | | Return: | 7/3/2002 | 7/26/2002 | 7/30/2002 | | ? | | Yes, I've changed the dates in the database from 7/3/2002 to 7/03/2002 and | it fixes it. Is the only answer to change the way the date is appended to | the database? Should I be working with #ofdays since.. format. I think I | know that answer.... :) | | GK ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Another date range search Q (Brian Fries 2002)
  2. Re: Another date range search Q (Gary Krockover 2002)
  3. Another date range search Q (Gary Krockover 2002)
Ok then, why does this (from the online docs): [Format Days_To_Date %m/%d/%y]195462[/Format]Return this?: 02/27/*+Latest WebDNA, Win2kadvserv.Why don't I just go home for the day? GK | Why does this search: | [Search db=report.db&eqacctdatarq=[acct]&rnddatedatarq=[startdate] | [enddate]&startdatetype=date&enddatetype=date&ddatetype=date&ddatesort=1&dda | tesdir=de] | | startdate: 7/23/2002 | enddate: 7/30/2002 | | Return: | 7/3/2002 | 7/26/2002 | 7/30/2002 | | ? | | Yes, I've changed the dates in the database from 7/3/2002 to 7/03/2002 and | it fixes it. Is the only answer to change the way the date is appended to | the database? Should I be working with #ofdays since.. format. I think I | know that answer.... :) | | GK ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Gary Krockover

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:

WebCatalog for guestbook ? (1997) FW: Shipping calculations (1997) unable to launch acgi in WebCat (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) PCS Frames (1997) [cart] not being interpreted inside [founditems] (1997) PIXO support (1997) A few questions. . . (1997) Plugin or CGI or both (1997) WebCat2: Found Items syntax, etc. (1997) [OT] (waaaay OT) (2004) FEW QUESTIONS (1997) Shipping still a problem!! (1998) Mac GUI editors (1997) Generating Report Totals (1997) Nesting [ListFiles] (1998) database size? (1997) [Replace] really replaces? (2000) Summing fields (1997) Trouble with formula.db (1997)