Re: Date Help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56427
interpreted = N
texte = Note that I'm missing a space between my [SDate] and [EDate] in this statement: rnTSDATEdatarq=[SDate][EDate].... Seems you have it working now anyways... GK At 11:09 AM 2/27/2004, you wrote: >Try: > >[text]SDate=01/[date %m]/[date %Y][/text] [!]- >01/02/2004[/!] SDate=[SDate]
>[text]EDate=[math date]{01/[date %m]/[date %Y]}+1[/math][/text] [!]- >01/03/2004[/!] EDate=[EDate]
> > >[search db=admin/-Timesheets.db&[!] >[/!]eqTSUserNamedatarq=[USERNAME]&[!] >[/!]rnTSDATEdatarq=[SDate][EDate]&[!] >[/!]asTSDATEsort=1&[!] >[/!]TSDATEtype=date] > >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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Date Help - Searching the same field twice ( "Scott Anderson" 2004)
  2. Re: Date Help ( Gary Krockover 2004)
  3. Re: Date Help ( Steve Craig 2004)
  4. Re: Date Help ( Gary Krockover 2004)
  5. Re: Date Help ( Steve Craig 2004)
  6. Re: Date Help ( Brian Fries 2004)
  7. Re: Date Help ( "WebDna @ Inkblot Media" 2004)
  8. Re: Date Help ( Donovan Brooke 2004)
  9. Re: Date Help ( Donovan Brooke 2004)
  10. Re: Date Help ( Pat Holliday 2004)
  11. Re: Date Help ( Gary Krockover 2004)
  12. Date Help ( Steve Craig 2004)
  13. Re: Date Help! (Dan Strong 2003)
  14. Re: Date Help! (Lester Emo 2003)
  15. Re: Date Help! (Dan Strong 2003)
  16. Re: Date Help! (Lester Emo 2003)
  17. Re: Date Help! (Glenn Busbin 2003)
  18. Re: Date Help! (Lester Emo 2003)
  19. Re: Date Help! (Dan Strong 2003)
  20. Re: Date Help! (Lester Emo 2003)
  21. Re: Date Help! (Dan Strong 2003)
Note that I'm missing a space between my [SDate] and [EDate] in this statement: rnTSDATEdatarq=[SDate][EDate].... Seems you have it working now anyways... GK At 11:09 AM 2/27/2004, you wrote: >Try: > >[text]SDate=01/[date %m]/[date %Y][/text] [!]- >01/02/2004[/!] SDate=[SDate]
>[text]EDate=[math date]{01/[date %m]/[date %Y]}+1[/math][/text] [!]- >01/03/2004[/!] EDate=[EDate]
> > >[search db=admin/-Timesheets.db&[!] >[/!]eqTSUserNamedatarq=[username]&[!] >[/!]rnTSDATEdatarq=[SDate][EDate]&[!] >[/!]asTSDATEsort=1&[!] >[/!]TSDATEtype=date] > >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://webdna.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 4.0.2b5 available (2000) WebCat2b13MacPlugIn - syntax to convert date (1997) Setting up WebCatalog with Retail Pro data (1996) Nested tags count question (1997) invoice.tpl (1998) Different Tax levels (1998) Fun with dates (1997) BUG in [showif] using ^ (contains) (1997) page chokes on hideif when false and ignored (1998) carriage returns in data (1997) [WebDNA] re: (2012) RAM variables (1997) [WebDNA] Kickstarter project - CodeBabel (2013) WebCat 2.1.3 (and docs) (1998) headers (2000) Is there a way to just get to the last record in the database? (1997) What am I missing (1997) emailer settings and control questions (1997) RequiredFields template (1997) MATH (1998)