Re: Date Help

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 56423
interpreted = N
texte = 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 At 10:56 AM 2/27/2004, you wrote: >Thanks for the replies on this so far but still no joy. If I just use one of >the date bits then I get a correct answer, it's just when I do both that the >problem happens. > >With this particular example I get nothing returned at all with both parts >of the expression and a correct answer if I just use one of them. > >Any other ideas? > >Cheers >Steve ------------------------------------------------------------- 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)
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 At 10:56 AM 2/27/2004, you wrote: >Thanks for the replies on this so far but still no joy. If I just use one of >the date bits then I get a correct answer, it's just when I do both that the >problem happens. > >With this particular example I get nothing returned at all with both parts >of the expression and a correct answer if I just use one of them. > >Any other ideas? > >Cheers >Steve ------------------------------------------------------------- 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:

Disappearing data (2002) Text data with spaces in them... (1997) Attaching a plain text file via [sendmail] (2001) all db's in one folder and protected (1998) tcpconnect timeout with Authorizenet (2003) Netscape v. IE (1997) Bug fix time lines ... (2000) Word search (1997) Emailer errors (1997) show all problem (1997) Cart Already Submitted (2003) Time Remaining? (1998) Trouble with formula.db (1997) Part 2 - [showif] if variable exists (1998) [protect admin] (1997) Forms (1998) Max Record length (1997) Bug Report, maybe (1997) Review comparison by PC Magazine: Open for On-line Business (1997) Robert Minor duplicate mail (1997)