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]GKAt 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:
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]GKAt 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)