Re: Help with dates
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38251
interpreted = N
texte = Gorana Leahy wrote:> > Hi all,> > I hope that someone can help me with this problem.> > I need to display quantity for a given number of months and this is the code> I am using:> > [loop start=0&end=[math][txtmonths]-1[/math]]> > > [search db=some.db&eqIDdatarq=[ID]&rnDaydatarq=01/[MyMonth]> 31/[MyMonth]&Daytype=date]> [founditems]> > > [/founditems]> [/search]>
[MyMonth]> [math]MonthTotal[/math]> [/loop]> > These are the results:> > 08/2001 1106> 07/2001 1044> 06/2001 0> 05/2001 0> 04/2001 0> 03/2001 0> 03/2001 0> 01/2001 0> 12/2000 0> 11/2000 0> > For some reason I keep on getting March instead of February.> I tryed everything to solve the problem but nothing works.> PLEASE HELP?! :)Try using [math date] instead (as the docs say): [math date]{[date]}-{00/[index]/0000}[/Math]HTHJohn--John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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:
Gorana Leahy wrote:> > Hi all,> > I hope that someone can help me with this problem.> > I need to display quantity for a given number of months and this is the code> I am using:> > [loop start=0&end=[math][txtmonths]-1[/math]]> > > [search db=some.db&eqIDdatarq=[ID]&rnDaydatarq=01/[MyMonth]> 31/[MyMonth]&Daytype=date]> [founditems]> > > [/founditems]> [/search]>
[MyMonth]> [math]MonthTotal[/math]> [/loop]> > These are the results:> > 08/2001 1106> 07/2001 1044> 06/2001 0> 05/2001 0> 04/2001 0> 03/2001 0> 03/2001 0> 01/2001 0> 12/2000 0> 11/2000 0> > For some reason I keep on getting March instead of February.> I tryed everything to solve the problem but nothing works.> PLEASE HELP?! :)Try using [math date] instead (as the docs say): [math date]{[date]}-{00/[index]/0000}[/Math]HTHJohn--John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 301-429-5747-------------------------------------------------------------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/
John Peacock
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:
Search probl. since change WebCatalog from 2.1.3 to 3.0 (1998)
TinyStore Question (1999)
How about this? (1998)
More DateMath problems (1997)
WebCat and image maps (1997)
WC2.0 Memory Requirements (1997)
Emailer to include Human Name with email Address (2000)
Nesting format tags (1997)
Using Plug-In while running 1.6.1 (1997)
Documentation Feedback (1997)
strip .0 off off IPaddress (1998)
bug in wn searching NT version? (1997)
textarea to page display (1998)
[SHOWIF AND/OR] (1997)
A multi-processor savvy WebCatalog? (1997)
WebTEN vs webSTARtopic (1998)
Applescript, WebDNA, and PDF (1997)
About the Allow 'Absolute Path' Prefix (2002)
really wierd browser truncating (1997)
[WebDNA] An unknown error occured // Deadlock avoided (2011)