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:

select multiple 2 more cents (1997) New Site Announcement (1998) WebCatalog-NT?'s (1996) weird text problem (2001) Summing results of a nested search (2006) Resetting a Formvariable (2000) FireSite and PIXO (1998) question: search return in order (1997) Getting the domain of every request ... (2003) Ampersand (1997) [WebDNA] WebDNA 6.1 Info (2008) Sendmail (2000) WebCat for Unix?? (1997) using showpage and showcart commands (1996) Re requiredFields parameter (1998) [WebDNA] WebDNA as cgi app (was WebSite Examples) (2008) Authorize.net? (2003) finding child records of child records of child records... with minimal code (2000) Setting up the server (1997) [WebDNA] Upgrade from OS 10.7.5 WebDNA 6.2 to Mavericks (2014)